Mongo management studio query12/8/2023 ![]() The Data Virtualization extension for Azure Data Studio and sp_data_source_table_columns use the same internal stored procedures to query the external schema schema. You can also manually customize a script based on the output of the system stored procedure sp_data_source_objects (Transact-SQL). You can use the Data Virtualization extension for Azure Data Studio to connect to and generate a CREATE EXTERNAL TABLE statement based on the schema detected by the PolyBase ODBC Driver for MongoDB driver. Optionally you can specify PUSHDOWN = ON or PUSHDOWN = OFF if you want to specify pushdown computation to the external source.ĬREATE EXTERNAL DATA SOURCE external_data_source_name.Replace with the name of the credential you created in the previous step.Before you run the script update it for your environment: For reference, see CREATE EXTERNAL DATA SOURCE. The following script creates the external data source. The MongoDB ODBC Connector for PolyBase supports only basic authentication, not Kerberos authentication. Replace with the appropriate password.ĬREATE DATABASE SCOPED CREDENTIAL WITH IDENTITY = '', Secret = ''.Replace with the user name for the external source.Replace with a name for the credential.The following script creates a database scoped credential. CREATE EXTERNAL DATA SOURCE (Transact-SQL)Ĭreate a database scoped credential for accessing the MongoDB source.CREATE DATABASE SCOPED CREDENTIAL (Transact-SQL).The following Transact-SQL commands are used in this section: ![]() This section provides sample code to create these external tables. To query the data from a MongoDB data source, you must create external tables to reference the external data. For more information, see CREATE MASTER KEY. If you haven't installed PolyBase, see PolyBase installation.īefore you create a database scoped credential, the database must have a master key to protect the credential. The article explains how to use PolyBase on a SQL Server instance to query external data in MongoDB. ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |