Forum Discussion
publicly available data
Yes, I tried that solution and it was still the low counts. I finally found the new URLs for the data. It actually was moved. thanks
COPY INTO [dbo].[dimension_city] FROM 'https://fabrictutorialdata.blob.core.windows.net/sampledata/WideWorldImportersDW/parquet/full/dimension_city' WITH (FILE_TYPE = 'PARQUET');
COPY INTO [dbo].[fact_sale] FROM 'https://fabrictutorialdata.blob.core.windows.net/sampledata/WideWorldImportersDW/parquet/full/fact_sale' WITH (FILE_TYPE = 'PARQUET');
Yes, I tried that solution and it was still the low counts. I finally found the new URLs for the data. It actually was moved. thanks
COPY INTO [dbo].[dimension_city] FROM 'https://fabrictutorialdata.blob.core.windows.net/sampledata/WideWorldImportersDW/parquet/full/dimension_city' WITH (FILE_TYPE = 'PARQUET');
COPY INTO [dbo].[fact_sale] FROM 'https://fabrictutorialdata.blob.core.windows.net/sampledata/WideWorldImportersDW/parquet/full/fact_sale' WITH (FILE_TYPE = 'PARQUET');
HI trindadsth,
Thanks for confirming. Glad you found the updated URLs and resolved the issue after the data was moved. The new COPY INTO paths should load the expected data correctly. So Accept your reply as the solution, as it will be helpful for other community members facing the same issue.
Thank you.