Forum Discussion

DennesTorres's avatar
DennesTorres
Impactful Individual
3 years ago
Solved

Copy INTO from authenticated source

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 o...
data warehouse
DennesTorres's avatar
DennesTorres
Impactful Individual
3 years ago


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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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