{"class_fqid":"com-snaplogic-pipeline_8","snode_id":"5c7ec36a36b98b179affa214","instance_id":"f1741169-a8e7-44c3-9391-685b10638292","instance_version":69,"link_map":{"link110":{"src_view_id":"output0","dst_view_id":"input101","src_id":"b7956b9b-5e3f-42e7-90cc-529a75670ca5","dst_id":"35861d82-1fbe-4bc4-b9ac-c017854ce299","isGoto":false},"link112":{"src_view_id":"output0","dst_view_id":"input101","src_id":"35861d82-1fbe-4bc4-b9ac-c017854ce299","dst_id":"67932a72-4fc7-4871-9857-e5479af4897a","isGoto":false},"link117":{"src_view_id":"output0","dst_view_id":"inputRows","src_id":"10dc7e42-b6cf-4a4d-8fc8-b5aaf7872d25","dst_id":"35861d82-1fbe-4bc4-b9ac-c017854ce299","isGoto":false}},"link_serial":119,"property_map":{"info":{"notes":{"value":null},"author":{"value":"smanoharan@snaplogic.com"},"purpose":{"value":null},"pipeline_doc_uri":{"value":null},"label":{"value":"Snowflake_Bulkload_FileFormatOption"}},"input":{},"settings":{"imports":{"value":[]},"suspendable":{"value":false},"error_param_table":{"value":[]},"param_table":{"value":[]},"error_pipeline":{"expression":false,"value":null}},"error":{"error_behavior":{"value":"none"}},"output":{"67932a72-4fc7-4871-9857-e5479af4897a_output0":{"view_type":{"value":"document"},"label":{"value":"Snowflake - Execute - output0"}}}},"render_map":{"pan_x_num":0,"default_snaplex":"55772b8495526e3fc62ac7ea","scale_ratio":1,"detail_map":{"67932a72-4fc7-4871-9857-e5479af4897a":{"grid_x_int":3,"index":null,"recommendation_id":null,"source":"","grid_y_int":2,"rot_tail_int":0,"rot_int":0},"10dc7e42-b6cf-4a4d-8fc8-b5aaf7872d25":{"grid_x_int":1,"index":null,"recommendation_id":null,"source":"","grid_y_int":2,"rot_tail_int":0,"rot_int":0},"b7956b9b-5e3f-42e7-90cc-529a75670ca5":{"grid_x_int":1,"index":null,"recommendation_id":null,"source":"snap catagory","grid_y_int":3,"rot_tail_int":0,"rot_int":0},"35861d82-1fbe-4bc4-b9ac-c017854ce299":{"grid_x_int":2,"index":null,"recommendation_id":null,"source":"snap catagory","grid_y_int":2,"rot_tail_int":0,"input":{"input101":{"dx_int":0,"rot_int":0,"dy_int":1}},"rot_int":0}},"pan_y_num":0},"snap_map":{"67932a72-4fc7-4871-9857-e5479af4897a":{"class_fqid":"com-snaplogic-snaps-snowflake-execute_1-SNAPSHOT","class_id":"com-snaplogic-snaps-snowflake-execute","class_version":1,"instance_fqid":"67932a72-4fc7-4871-9857-e5479af4897a_5","instance_id":"67932a72-4fc7-4871-9857-e5479af4897a","instance_version":5,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Snowflake - Execute"}},"view_serial":101,"account":{"account_ref":{"expression":false,"value":{"ref_id":{"expression":false,"value":"2103b3bc-3d44-44d8-9bfc-f97e182b93b8"},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-snowflakedatabaseaccount"},"label":{"expression":false,"value":"Snowflake Shared SNAPQADB"}}}},"input":{"input101":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"settings":{"execution_mode":{"value":"ENABLED"},"maxRetryProp":{"expression":false,"value":5},"passThrough":{"value":true},"useResultQuery":{"value":false},"executable_during_suggest":{"value":true},"sqlStatement":{"expression":false,"value":"select * from TestTable;"},"ignoreEmptyResult":{"value":false},"retryIntervalProp":{"expression":false,"value":3}},"error":{"error0":{"label":{"value":"error0"},"view_type":{"value":"document"}},"error_behavior":{"value":"fail"}},"output":{"output0":{"label":{"value":"output0"},"view_type":{"value":"document"}}}},"class_build_tag":"SNAPSHOT"},"10dc7e42-b6cf-4a4d-8fc8-b5aaf7872d25":{"class_fqid":"com-snaplogic-snaps-transform-jsongenerator_2-SNAPSHOT","class_id":"com-snaplogic-snaps-transform-jsongenerator","class_version":2,"instance_fqid":"10dc7e42-b6cf-4a4d-8fc8-b5aaf7872d25_7","instance_id":"10dc7e42-b6cf-4a4d-8fc8-b5aaf7872d25","instance_version":7,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Data"}},"view_serial":101,"settings":{"editable_content":{"value":"[{\"DIMENSION_KEY\":77,\"ACCOUNT_ID\":\"1752\",\"ACCOUNT_NAME\":\"  TestInfo\",\"ACCOUNT_DESC\":\"TestInfo\",\"ACCOUNT_TYPE\":\"PORTFOLIO\",\"ACCOUNT_REL_ID\":null,\"ACCOUNT_KEY\":77}]"},"execution_mode":{"value":"ENABLED"},"arrayElementsAsDocuments":{"value":true}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"output0"}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}}},"class_build_tag":"SNAPSHOT"},"b7956b9b-5e3f-42e7-90cc-529a75670ca5":{"class_fqid":"com-snaplogic-snaps-transform-jsongenerator_2-SNAPSHOT","class_id":"com-snaplogic-snaps-transform-jsongenerator","class_version":2,"instance_fqid":"b7956b9b-5e3f-42e7-90cc-529a75670ca5_2","instance_id":"b7956b9b-5e3f-42e7-90cc-529a75670ca5","instance_version":2,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Schema"}},"view_serial":100,"settings":{"editable_content":{"value":"[{\"databaseMajorVersion\":12,\"databaseProductVersion\":\"Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production\\nWith the Partitioning, OLAP, Advanced Analytics and Real Application Testing options\",\"primaryKeyColumns\":{\"DIMENSION_KEY\":{\"TABLE_CAT\":null,\"TABLE_NAME\":\"DIM_ACCOUNT\",\"PK_NAME\":\"DIM_MACC_PK\",\"KEY_SEQ\":1,\"TABLE_SCHEM\":\"AP2DW\",\"COLUMN_NAME\":\"DIMENSION_KEY\"}},\"databaseProductName\":\"Oracle\",\"columns\":{\"ACCOUNT_NAME\":{\"SCOPE_TABLE\":null,\"TABLE_CAT\":null,\"BUFFER_LENGTH\":0,\"IS_NULLABLE\":\"YES\",\"TABLE_NAME\":\"DIM_ACCOUNT\",\"COLUMN_DEF\":null,\"SCOPE_CATALOG\":null,\"TABLE_SCHEM\":\"AP2DW\",\"COLUMN_NAME\":\"ACCOUNT_NAME\",\"NULLABLE\":\"columnNullable\",\"REMARKS\":null,\"DECIMAL_DIGITS\":null,\"NUM_PREC_RADIX\":10,\"SQL_DATETIME_SUB\":0,\"IS_AUTOINCREMENT\":\"NO\",\"SQL_DATA_TYPE\":0,\"CHAR_OCTET_LENGTH\":100,\"ORDINAL_POSITION\":3,\"SCOPE_SCHEMA\":null,\"SOURCE_DATA_TYPE\":null,\"DATA_TYPE\":\"VARCHAR\",\"TYPE_NAME\":\"VARCHAR2\",\"COLUMN_SIZE\":100},\"ACCOUNT_TYPE\":{\"SCOPE_TABLE\":null,\"TABLE_CAT\":null,\"BUFFER_LENGTH\":0,\"IS_NULLABLE\":\"YES\",\"TABLE_NAME\":\"DIM_ACCOUNT\",\"COLUMN_DEF\":null,\"SCOPE_CATALOG\":null,\"TABLE_SCHEM\":\"AP2DW\",\"COLUMN_NAME\":\"ACCOUNT_TYPE\",\"NULLABLE\":\"columnNullable\",\"REMARKS\":null,\"DECIMAL_DIGITS\":null,\"NUM_PREC_RADIX\":10,\"SQL_DATETIME_SUB\":0,\"IS_AUTOINCREMENT\":\"NO\",\"SQL_DATA_TYPE\":0,\"CHAR_OCTET_LENGTH\":30,\"ORDINAL_POSITION\":5,\"SCOPE_SCHEMA\":null,\"SOURCE_DATA_TYPE\":null,\"DATA_TYPE\":\"VARCHAR\",\"TYPE_NAME\":\"VARCHAR2\",\"COLUMN_SIZE\":30},\"DIMENSION_KEY\":{\"TABLE_CAT\":null,\"BUFFER_LENGTH\":0,\"_SL_DISPLAY_SIZE\":39,\"TABLE_NAME\":\"DIM_ACCOUNT\",\"COLUMN_DEF\":null,\"SCOPE_CATALOG\":null,\"TABLE_SCHEM\":\"AP2DW\",\"COLUMN_NAME\":\"DIMENSION_KEY\",\"REMARKS\":null,\"NUM_PREC_RADIX\":10,\"IS_AUTOINCREMENT\":\"NO\",\"SQL_DATA_TYPE\":0,\"SCOPE_SCHEMA\":null,\"DATA_TYPE\":\"DECIMAL\",\"COLUMN_SIZE\":0,\"SCOPE_TABLE\":null,\"IS_NULLABLE\":\"NO\",\"NULLABLE\":\"columnNoNulls\",\"DECIMAL_DIGITS\":-127,\"_SL_SCALE\":-127,\"SQL_DATETIME_SUB\":0,\"CHAR_OCTET_LENGTH\":null,\"_SL_PRECISION\":0,\"ORDINAL_POSITION\":1,\"SOURCE_DATA_TYPE\":null,\"TYPE_NAME\":\"NUMBER\"},\"ACCOUNT_ID\":{\"SCOPE_TABLE\":null,\"TABLE_CAT\":null,\"BUFFER_LENGTH\":0,\"IS_NULLABLE\":\"YES\",\"TABLE_NAME\":\"DIM_ACCOUNT\",\"COLUMN_DEF\":null,\"SCOPE_CATALOG\":null,\"TABLE_SCHEM\":\"AP2DW\",\"COLUMN_NAME\":\"ACCOUNT_ID\",\"NULLABLE\":\"columnNullable\",\"REMARKS\":null,\"DECIMAL_DIGITS\":null,\"NUM_PREC_RADIX\":10,\"SQL_DATETIME_SUB\":0,\"IS_AUTOINCREMENT\":\"NO\",\"SQL_DATA_TYPE\":0,\"CHAR_OCTET_LENGTH\":30,\"ORDINAL_POSITION\":2,\"SCOPE_SCHEMA\":null,\"SOURCE_DATA_TYPE\":null,\"DATA_TYPE\":\"VARCHAR\",\"TYPE_NAME\":\"VARCHAR2\",\"COLUMN_SIZE\":30},\"ACCOUNT_REL_ID\":{\"SCOPE_TABLE\":null,\"TABLE_CAT\":null,\"BUFFER_LENGTH\":0,\"IS_NULLABLE\":\"YES\",\"TABLE_NAME\":\"DIM_ACCOUNT\",\"COLUMN_DEF\":null,\"SCOPE_CATALOG\":null,\"TABLE_SCHEM\":\"AP2DW\",\"COLUMN_NAME\":\"ACCOUNT_REL_ID\",\"NULLABLE\":\"columnNullable\",\"REMARKS\":null,\"DECIMAL_DIGITS\":null,\"NUM_PREC_RADIX\":10,\"SQL_DATETIME_SUB\":0,\"IS_AUTOINCREMENT\":\"NO\",\"SQL_DATA_TYPE\":0,\"CHAR_OCTET_LENGTH\":30,\"ORDINAL_POSITION\":6,\"SCOPE_SCHEMA\":null,\"SOURCE_DATA_TYPE\":null,\"DATA_TYPE\":\"VARCHAR\",\"TYPE_NAME\":\"VARCHAR2\",\"COLUMN_SIZE\":30},\"ACCOUNT_KEY\":{\"TABLE_CAT\":null,\"BUFFER_LENGTH\":0,\"_SL_DISPLAY_SIZE\":39,\"TABLE_NAME\":\"DIM_ACCOUNT\",\"COLUMN_DEF\":null,\"SCOPE_CATALOG\":null,\"TABLE_SCHEM\":\"AP2DW\",\"COLUMN_NAME\":\"ACCOUNT_KEY\",\"REMARKS\":null,\"NUM_PREC_RADIX\":10,\"IS_AUTOINCREMENT\":\"NO\",\"SQL_DATA_TYPE\":0,\"SCOPE_SCHEMA\":null,\"DATA_TYPE\":\"DECIMAL\",\"COLUMN_SIZE\":0,\"SCOPE_TABLE\":null,\"IS_NULLABLE\":\"YES\",\"NULLABLE\":\"columnNullable\",\"DECIMAL_DIGITS\":-127,\"_SL_SCALE\":-127,\"SQL_DATETIME_SUB\":0,\"CHAR_OCTET_LENGTH\":null,\"_SL_PRECISION\":0,\"ORDINAL_POSITION\":7,\"SOURCE_DATA_TYPE\":null,\"TYPE_NAME\":\"NUMBER\"},\"ACCOUNT_DESC\":{\"SCOPE_TABLE\":null,\"TABLE_CAT\":null,\"BUFFER_LENGTH\":0,\"IS_NULLABLE\":\"YES\",\"TABLE_NAME\":\"DIM_ACCOUNT\",\"COLUMN_DEF\":null,\"SCOPE_CATALOG\":null,\"TABLE_SCHEM\":\"AP2DW\",\"COLUMN_NAME\":\"ACCOUNT_DESC\",\"NULLABLE\":\"columnNullable\",\"REMARKS\":null,\"DECIMAL_DIGITS\":null,\"NUM_PREC_RADIX\":10,\"SQL_DATETIME_SUB\":0,\"IS_AUTOINCREMENT\":\"NO\",\"SQL_DATA_TYPE\":0,\"CHAR_OCTET_LENGTH\":300,\"ORDINAL_POSITION\":4,\"SCOPE_SCHEMA\":null,\"SOURCE_DATA_TYPE\":null,\"DATA_TYPE\":\"VARCHAR\",\"TYPE_NAME\":\"VARCHAR2\",\"COLUMN_SIZE\":300}},\"databaseMinorVersion\":1,\"indexInfo\":{\"DIM_MACC_PK\":[{\"NON_UNIQUE\":0,\"TABLE_CAT\":null,\"PAGES\":1,\"TABLE_NAME\":\"DIM_ACCOUNT\",\"TABLE_SCHEM\":\"AP2DW\",\"COLUMN_NAME\":\"DIMENSION_KEY\",\"INDEX_NAME\":\"DIM_MACC_PK\",\"ASC_OR_DESC\":null,\"INDEX_QUALIFIER\":null,\"ORDINAL_POSITION\":1,\"CARDINALITY\":75,\"FILTER_CONDITION\":null,\"TYPE\":1}]},\"importedKeys\":{},\"declaration\":{\"TABLE_CAT\":null,\"TABLE_NAME\":\"DIM_ACCOUNT\",\"TABLE_TYPE\":\"TABLE\",\"REMARKS\":null,\"TABLE_SCHEM\":\"AP2DW\"}}]"},"execution_mode":{"value":"ENABLED"},"arrayElementsAsDocuments":{"value":true}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"output0"}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}}},"class_build_tag":"SNAPSHOT"},"35861d82-1fbe-4bc4-b9ac-c017854ce299":{"class_fqid":"com-snaplogic-snaps-snowflake-bulkload_1-snapsrc1030","class_id":"com-snaplogic-snaps-snowflake-bulkload","class_version":1,"instance_fqid":"35861d82-1fbe-4bc4-b9ac-c017854ce299_22","instance_id":"35861d82-1fbe-4bc4-b9ac-c017854ce299","instance_version":22,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Snowflake - Bulk Load"}},"view_serial":101,"account":{"account_ref":{"expression":false,"value":{"label":{"expression":false,"value":"Snowflake Shared SNAPQADB"},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-snowflakedatabaseaccount"},"ref_id":{"expression":false,"value":"2103b3bc-3d44-44d8-9bfc-f97e182b93b8"}}}},"input":{"inputRows":{"view_type":{"value":"document"},"label":{"value":"rows"}},"input101":{"label":{"value":"input1"},"view_type":{"value":"document"}}},"settings":{"loadEmptyStrings":{"value":false},"fileFormatType":{"value":"NONE"},"execution_mode":{"value":"ENABLED"},"staging":{"expression":false,"value":null},"fileNamePattern":{"expression":false,"value":null},"tableName":{"expression":false,"value":"TestTable"},"fileFormatObject":{"expression":false,"value":null},"ConvertInputKeyNamesToUpperCase":{"value":true},"executable_during_suggest":{"value":true},"rowsToReturn":{"value":0},"createTable":{"value":true},"additionalOptions":{"value":{"errorPercentageLimit":{"value":0},"force":{"value":false},"onError":{"value":"ABORT_STATEMENT"},"purge":{"value":false},"returnFailedOnly":{"value":false},"sizeLimit":{"value":0},"bufferSize":{"value":null},"errorLimit":{"value":0}}},"columnList":{"value":[]},"stagingLocation":{"value":"Internal"},"schemaName":{"expression":false,"value":"\"PUBLIC\""},"fileFormatOption":{"expression":false,"value":"TRIM_SPACE=TRUE"},"validationMode":{"value":"NONE"},"stagedFileList":{"value":[]},"dataSource":{"value":"Input view"}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"output0"}}}},"class_build_tag":"snapsrc1030"}},"path_id":"/QA/Documentation/Snowflake Pipelines","path_snode":"5bb5bc2d36b98b001e81d3fb","target_runtime":"standard","snap_history":{"67932a72-4fc7-4871-9857-e5479af4897a":{"index":null,"added_ts":1551954838510,"is_deleted":false,"class_id":"com-snaplogic-snaps-snowflake-execute","recommendation_id":null,"source":"copy","deleted_ts":null},"0cd98ac9-f44f-42f7-b64e-52382b384ae9":{"index":null,"added_ts":1551815110076,"is_deleted":true,"class_id":"com-snaplogic-snaps-transform-datatransform","recommendation_id":null,"source":"snap catagory","deleted_ts":1552987774753},"2f3638cc-280c-4d19-aaec-df491cdd138b":{"class_id":"com-snaplogic-snaps-snowflake-bulkload","is_deleted":true,"deleted_ts":1551954790705},"48a38681-bc96-40c5-8d43-b2e96f0e9846":{"class_id":"com-snaplogic-snaps-snowflake-execute","is_deleted":true,"deleted_ts":1552987330629},"981e59ba-1020-4162-b120-be7ec0aea63c":{"index":null,"added_ts":1553088477859,"is_deleted":true,"class_id":"com-snaplogic-snaps-snowflake-execute","recommendation_id":null,"source":"copy","deleted_ts":1553089278338},"a987e74d-a2d7-4814-80dd-8c946c060fb2":{"index":null,"added_ts":1552647711269,"is_deleted":true,"class_id":"com-snaplogic-snaps-test-assertequals","recommendation_id":null,"source":"snap catagory","deleted_ts":1552987728582},"fc60feec-0dd7-4e1e-9d70-5fe5a27c9041":{"index":null,"added_ts":1551815185172,"is_deleted":true,"class_id":"com-snaplogic-snaps-test-assertequals","recommendation_id":null,"source":"snap catagory","deleted_ts":1552647717371},"64dd91be-ce96-479c-8892-3e98f36806d7":{"class_id":"com-snaplogic-snaps-transform-jsongenerator","is_deleted":true,"deleted_ts":1552987328606},"c95bc280-97ea-414a-8c52-ce8fdf96106f":{"class_id":"com-snaplogic-snaps-snowflake-execute","is_deleted":true,"deleted_ts":1552987332609},"35861d82-1fbe-4bc4-b9ac-c017854ce299":{"index":null,"added_ts":1551953294022,"is_deleted":false,"class_id":"com-snaplogic-snaps-snowflake-bulkload","recommendation_id":null,"source":"snap catagory","deleted_ts":null},"10dc7e42-b6cf-4a4d-8fc8-b5aaf7872d25":{"index":null,"added_ts":1552646830310,"is_deleted":false,"class_id":"com-snaplogic-snaps-transform-jsongenerator","recommendation_id":null,"source":"copy","deleted_ts":null},"x261":{"index":null,"added_ts":1552561158764,"is_deleted":true,"class_id":"com-snaplogic-snaps-oracle-insert","recommendation_id":null,"source":"snap catagory","deleted_ts":1552561166696},"7a5f7b98-31e8-405d-a65f-3be81de2fc90":{"index":null,"added_ts":1551954892292,"is_deleted":true,"class_id":"com-snaplogic-snaps-snowflake-execute","recommendation_id":null,"source":"copy","deleted_ts":1552987497472}}}