mangeshj
New Contributor
Joined 5 years ago
User Profile
User Widgets
Contributions
Re: SCD 2 in snaplogic with snowflake as target table
Hi rsramkoski, Attaching screen shot of the snaps and table structure and src file person_src.txt (88 Bytes) and this is table structure with initial one record insert into snp_scd_usecase_Person (id , first_name, last_name, AGE, current_row, start_date, end_date) values (5,‘Vishal’,‘Singh’,30,1,current_date-2,current_date-1) and source file has updated record with age = 32 so i want output with two records along with start date and end date sample output expected id name age current row 5 vishal 30 0 5 vishal 32 1 please suggest i got this error Failure: Input data contains no entry for natural key: $first_name, Reason: Input data contains no entry for natural key: $first_name, Resolution: Please check if input data has valid entries for Natural key but not able to resolve it . Regards, Mangesh3.2KViews0likes0CommentsRe: SCD 2 in snaplogic with snowflake as target table
thanks for the reply , i am trying resovled scd type 2 issue . still getting this error in SNOWFLAKE scd 2 snaps : Failure: Input data contains no entry for natural key: $first_name, Reason: Input data contains no entry for natural key: $first_name, Resolution: Please check if input data has valid entries for Natural key to implement scd 2 using snowflake , i have added one initial record in snowflake table and then adding corresponding updated record in local file and trying to read the same updated record from file reader . i am using file reader , csv parser , mapper , snowflakescd type 2 , snowflake bulk upsert snaps . some time it gives invalid identifier error for age column but it is resolved . but it is not updating existing record in snowflake and it is not inserting new record into snowflake Regards, Mangesh3.2KViews0likes2CommentsInvalid error for string field
hi team, i am getting the below error for simple string column first_name , while reading just loading csv file to snowflake table . is this a problem of snaps , as per error below , it is recommending below resolution Resolution: Please file a defect against the snap i have used Mapper snaps with Mapping table expression - $first_name and target path is $first_name . after executing pipeline , got below error . i am not sure what i am missing here . is there any access issue to create internal temporary table or missing some expression in column first_name error : Error creating or writing input data to the temp table “DET_INTERNAL_POC”.MERGE_TEMP_TABLE_31c9e4ce_4de1_4d24_8b77_e29a9d11a063 Resolution: Please file a defect against the snap Reason: SQL compilation error: error line 1 at position 116 invalid identifier ‘“first_name”’ Hide Details… Snowflake - Bulk Upsert[55aeb42a050186140d44b424_374b62e2-71de-42b7-bb21-2a541331415b – 1c44770d-9538-4f0b-80c7-8d558fa91a4b] com.snaplogic.snap.api.SnapDataException: Error creating or writing input data to the temp table “DET_INTERNAL_POC”.MERGE_TEMP_TABLE_31c9e4ce_4de1_4d24_8b77_e29a9d11a063 at com.snaplogic.snaps.snowflake.BulkUpsert.loadTempFileIntoTempTable(BulkUpsert.java:455) at com.snaplogic.snaps.snowflake.BulkUpsert.handle(BulkUpsert.java:391) at com.snaplogic.cc.snap.common.SnapRunnableImpl.callback(SnapRunnableImpl.java:840)2.6KViews0likes1CommentSCD 2 in snaplogic with snowflake as target table
hi team, would like to implement scd type 2 in snaplogic and target dw is snowflake table. scenario : 1) Need to select sample txt / json file from local drive 2) process file into snowflake table 3) what are the snaps and how it links in pipeline to capture scd type 2 scenario can anyone provides some guidance, i am not getting which snaps need to linked earlier i had used Json generator snaps , snowflake scd2 snaps and snowflake bulk upsert but it did not process json document . and there is no error . it did not read the json document Regards, Mangesh4.1KViews0likes4CommentsConnectivity to add Snowflake account (on azure) from Snaplogic
Hi All, I am trying to add Snowflake account (hosted on Azure) from Snaplogic and i had passed all details like Snowflake account name , user id , password , warehouse name , port , but getting error in JDBC driver . . this is the jdbc driver name : net.snowflake.client.jdbc.SnowflakeDriver selected while adding snowflake account and error is : Failed to validate account: Could not load JDBC driver for url: {{Default JDBC driver}} Cause: net.snowflake.client.jdbc.SnowflakeDriver (Reason: net.snowflake.client.jdbc.SnowflakeDriver; Resolution: Please verify that the driver exists at the provided location and that read permissions are granted or the JDBC Driver Class has been specified correctly in the account configuration) we are not sure whether this jdbc driver needs to installed on Snowflake (hosted on azure) if anyone can guide us Regards, Mangesh3.2KViews0likes2Comments