Orchestration Components

S3 unload

I need to upload some files to AWS in txt format pipe delimited from S3 Snowflake. The files load but it seems like its loading columns and rows in sequential...

query result to grid

After querying a result to grid how do you select from the grid variable and insert into a table? Please type sample syntax. Thanks,

SQL script

Is it possible to do an update join? IE: update a,b set a.col1 = b.col1 where a.col1 = b.col1

SQL query not executing

select "Mercy Field: SPCLTY_DSPLY_NM" from "processedsm" I'm getting SQL compilation error: error line 1 at position 7 invalid identifier '"Mercy Field: SPCLTY_DSPLY_NM"', eventhough I copied and pasted it directly from...

switching schemas

I created an orchestration with 9 sub orchestrations and it worked perfectly. But I needed to change schemas and now it doesn't recognize tables that have already been inserted at...

SQL script

with updateduplicateprimaryspecialtiestosecondary as ( select row_number() over (partition by providerexternalid order by providerexternalid) as rownumofisprimarybyproviderandisprime ,a.* from (select * from "unprocessedproviderspecialties" where isprimary = 'Y' )as a) update updateduplicateprimaryspecialtiestosecondary set...

table metadata to grid

Is it possible to create many tables by iterating through many table metadata to grid sources? im connecting an iterator to the table metadata grid component (with a variable containing...

table metadata to grid

Later in the package, is it possible for a "table metadata to grid" to have a table input from a variable with different table names that haven't been created before...

S3 and fixed iterator

I am trying to use a fixed iterator and s3 load to load 6 csv files from AWS to their corresponding tables that I have already created. It gets validated...

Excel error

Got error "Exception: GC overhead limit exceeded" while Trying to load Excel data of 1m records.