topic Re: Copy INTO from authenticated source in Data Warehouse

Copy INTO from authenticated source

DennesTorres — Mon, 07 Aug 2023 17:32:39 GMT

Hi,

Is there a way to use the COPY INTO SQL statement on a Data Warehouse when the storage source requires authentication?

I imagine an SAS key on the query string would work, but is this the only way?

Kind Regards,

Dennes

Re: Copy INTO from authenticated source

Anonymous — Tue, 08 Aug 2023 23:47:48 GMT

Hi DennesTorres Thanks for posting your question in Microsoft Fabric Community

you can use a SAS token or a storage account key with Fabric. If you need an example, you can find it here:COPY INTO (Transact-SQL) - Azure Synapse Analytics and Microsoft Fabric | Microsoft Learn

Regards

Geetha

Re: Copy INTO from authenticated source

DennesTorres — Wed, 09 Aug 2023 01:40:30 GMT

Thank you, Geetha, this helps if the source is an external storage, such as an azure data lake storage.

If the source is the "Files" area from a lakehouse, is it possible to retrieve an SAS key for the Files area, or is it not available yet ?

Kind Regards,

Dennes

Re: Copy INTO from authenticated source

Anonymous — Wed, 09 Aug 2023 20:52:27 GMT

DennesTorres We don't support COPY from OneLake quite yet. If your files are in the Lakehouse, are they delta tables? You can use CTAS from the Lakehouse, or even INSERT INTO ... SELECT. There are some examples in the "Ingesting data from tables on different warehouses and lakehouses" section of this article: Ingest data into your Warehouse using Transact-SQL - Microsoft Fabric | Microsoft Learn

Regards

Geetha