![]() Required to encrypt the credential secret in the next step. Only necessary if one does not already exist. Then use it when defining the location of the data source. To access data through a credential, use the following script to create a database-scoped credential. You don't need secure access to the public data since it's already accessible to anyone.ĭon't skip this step if you're using this tutorial as a template for loading your own data. ![]() Skip this step if you're loading the Contoso public data. ![]() The external object definitions are stored in dedicated SQL pools. PolyBase uses T-SQL external objects to define the location and attributes of the external data. If you don't have a data warehouse provisioned, see Create a data warehouse and set server-level firewall rule. To run this tutorial, you need an Azure account that already has a dedicated SQL pool. Perform optimizations after the load is finished.Configure PolyBase to load from Azure blob storage.In this tutorial, you learn to use PolyBase and T-SQL commands to load two tables from the Contoso retail data into dedicated SQL pools.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
June 2023
Categories |