Transformation Components

Deserialize JSON file

Greetings, I would like to check is there a way to deserialize a JSON file which is serialize using Jackson in Java?

JSON transformations

Hii below is my sample jSON i am trying to transform this into table , using manual jsonpaths file. . but getting error "invalid JSON path , member is not...

JSON transformations

Any advanced examples for explaining transformations on complex nested JSON data files in Matillion ?

how to map grid variables for source and Target table when source table count is less then target

Hi team, We need to load data from source to target using grid variables where Source table has less column then target , the column which is missing in target...

Full Outer Join Error

when joined 2 table with FULL join type, it throws following error. "Validation error. org.postgresql.util.PSQLException: ERROR: could not devise a query plan for the given query" Whereas, the same works...

Jython StringIO() error

Need create a stream in memory import boto3 import io f = io.StringIO() file_key = 'someDir/b_contracts.txt' s3 = boto3.resource('s3') for line in obj.get()['Body']._raw_stream: f.write(line.encode('utf-8')) TypeError: can't write str to text...

API profile - get the JSON elements into one single column

Hello, How can I dump each element of the JSON object into a column in a DB table (Snowflake) ? For what I have seen, one must specify the columns...

Cannot find Is_Json_Valid function in Calculator Component

Hi, I am unable to find the IS_VALID_JSON function ( https://docs.aws.amazon.com/redshift/latest/dg/IS_VALID_JSON.html ) in the Calculator Component of Matillion for Redshift. Where can I find this function?

Cassandra Data Query

Hello, I have a Cassandra whereby it is running on 6 nodes. Is there any configuration option in Cassandra component whereby to point the extraction to a specific node. Regards...

Adding timestamp to loaded records

Hi, what is the best way to add a timestamp to a target table? I am using Table Output Component but in the Column Mappings I can only select input...