Problem statement   Variables created in temporary tables (created by SAS) appear to not be available to use in Snowflake joins. This happens whether numeric or char variables in SAS.   Following code works fine. It creates the temp table (the DBMSTEMP option in libname set up the ability to update temp tables). TMP_DATA is the LIBNAME that points to the Snowflake schema. But it doesnt reference the temp table column in the join   data work.one ;  ar_id = 3 ; name = 'Beatles' ; output ;  ar_id = 2 ; name = 'Marmalade' ; output ; run ;  options SASTRACE=',,,d' sastraceloc=saslog; proc append base=tmp_data.DON_TEMP_TABLE_TEST    data=work.one ; run ;   title 'TEMP TABLE FROM APPEND' ; proc sql ; connect using TMP_DATA ; select * from connection to TMP_DATA (   describe table <<database>>.<<temp file schema>>.DON_TEMP_TABLE_TEST ; );   select * from connection to TMP_DATA ( select * from <<database>>.<<temp file schema>>.DON_TEMP_TABLE_TEST a inner join <<database>>.<<table schema>>.ar_translation b /* on a.ar_id = b.ar_id */ limit 2 );   and produces this output (some fields deliberately masked)       Now uncomment the commented out lines above (to make the SQL not do a cartesian join). This Snowflake error occurs:   ERROR: CLI prepare error: SQL compilation error: error line 1 at position 125 invalid identifier 'A.AR_ID' SQL statement: select * from <<database>>.<<temp file schema>>.DON_TEMP_TABLE_TEST a inner join <<database>>.<<table schema>>.ar_translation b on a.ar_id = b.ar_id.   So, only when used in a join, the variable is somehow invalid. I've tried random names not the same as the key in B but no difference. I've also uppercased everything and it still fails. Numeric and Char fail.   When I create a temp using SnowFLake to create the table, this does not happen, so I believe this is a SAS issue.   Has anyone else struck this?   I am tracking this to tech support as well.   Note that switching on the SAS trace gives no obvious usual info. Here it is (with a char variable rather than numeric used)   62 select * from connection to TMP_DATA 63 ( 64 select * from <<database>>.<<temp table schema>>.DON_TEMP_TABLE_TEST a 65 inner join<<database>>.<<table schema>>.ar_translation b 66 on a.ar_local_id = b.ar_local_id 67 limit 2 68 69 ); 30 2001018589 rtmdoit 32766 SQL (2) SNOWFLAKE_8: Prepared: on connection 0 31 2001018589 rtmdoit 32766 SQL (2) select * from<<database>>.<<temptable schema>>.DON_TEMP_TABLE_TEST a inner join<<database>>.<<table schema>>.ar_translation b on a.ar_local_id = b.ar_local_id limit 2 32 2001018589 rtmdoit 32766 SQL (2) 33 2001018589 rtmdoit 32766 SQL (2) ERROR: CLI prepare error: SQL compilation error: error line 1 at position 125 invalid identifier 'A.AR_LOCAL_ID' SQL statement: select * from <<database>>.<<temp table schema>>.DON_TEMP_TABLE_TEST a inner join <<database>>.<<table schema>>.ar_translation b on a.ar_local_id = b.ar_local_id limit 2. NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.   Thanks, Don     ... View more