Hi Team ,
Can we load a Json File from aws S3 into MemSQL database through Pipeline.
is there any way in MemSql which loads complete Json file into MemSQL standard data type
and once all json data in one column , we can transform this json elements and breaks into column and more readable format.
Note: i donot want to insert json data using Insert statement and i donot want to create a pre-defined mapping to load json files
I had process json files into snowflake through aws s3 and transform json data in snowflake using lateral function , so looking for the same in MemSQL