Forum Discussion

darshthakkar's avatar
darshthakkar
Valued Contributor
3 years ago
Solved

Reading data from an empty table in snowflake

How can we read an empty table from Snowflake - Select snap? While I use Snowflake - Select snap and the table is empty, I don’t see any output preview so I decided to write it down to a flat fil...
expression_language
pipeline
transform
  • koryknick's avatar
    koryknick
    5 months ago

    kumar25 - My dev team is stating that this is currently not supported by our Excel Parser snap.  My major concern with using a Script snap to handle the parsing is that the file would either need to be passed as a single binary document, consuming as much memory as the file size, which can be quite large, or you would need to place the file on the Snaplex node before parsing and ensure that the SnapLogic process has read permissions to it.  

    Having the Script snap perform the parsing also requires that you install and maintain the libraries required to parse. 

    While is is feasible, I might recommend that you see if the source can provide the more standard XLSX format before going that route.

darshthakkar's avatar
darshthakkar
Valued Contributor
3 years ago
Copy LinkReport

The whole point of reading data from an empty table in snowflake - select snap was to record the counts, as there is no easier way to do that when the table is empty, we can leverage the snowflake - execute snap and modify the query to get the counts ONLY.

Return data type is an integer for me which I don’t have any concern with and, if need be, that can be converted to a String. Thus, the easiest solution is to use a Snowflake - Execute snap instead of a Snowflake - Select and modify the query.

P.S.: All snowflake snaps trying to fetch data in an empty table wouldn’r return anything. Not even Null or 0.

Closing this thread now. Thank you.