I want to extract data from sharepoint to tables in snowflake, i try to configure sharepoint query component but it allows to extract metadata only. Do you have any idea how to do it?

Matillion ETL
1

i want to extract data from sharepoint to tables in snowflake, i try to configure sharepoint query component but it allows to extract metadata only. Do you have any idea how to do it?

2

Hi @NaimaH​

In short the component exposes sharepoint lists and document libraries as tables.

  • data in lists can be directly imported into tables in snowflake
  • List of files in a document library can be imported into a table in snowflake. This can expose the path to each file

If customers data is in a file in sharepoint —

  1. Use sharepoint component to retrieve the path of the file by importing the data from relevant document library (represented as a table)
  2. Use the file-path with a data-transfer component to copy the file from sharepoint to s3/azure blob
  3. Use relevant data-load component to load data into snowflake

Thanks,

Chika

3

Hi Chika

 

I'm really struggling with loading a file from SharePoint (OneDirve) into Snowflake.

 

Are you able to provide screenshots of how exactly to achieve the 3 steps you have noted?

  1. Use sharepoint component to retrieve the path of the file by importing the data from relevant document library (represented as a table)
  2. Use the file-path with a data-transfer component to copy the file from sharepoint to s3/azure blob
  3. Use relevant data-load component to load data into snowflake

 

Thanks,

AJ