How can I join data from Snowflake and Excel?

Data Sources
1

Hello All,

Please help with the below query,

How can I combine the excel data with the Snowflake database table data?

2

Hi @pippalla77

You’ll have to either add the Excel data as a CSV or use a tool to ingest the data into Snowflake.

Here’s how to upload a CSV: https://help.sigmacomputing.com/hc/en-us/articles/4405058977811-Upload-CSVs

Here’s the documentation on how to make joins in Sigma: https://help.sigmacomputing.com/hc/en-us/articles/4408784891667-Types-of-Joins

You could consider an Input Table depending on the size of the data and how often it needs to be updated: https://help.sigmacomputing.com/hc/en-us/articles/12397587156755-Input-Tables-Beta-

1 Like