Topics started by Akshay Hande

2 Topics

A
Active
Akshay HandeActive
asked in Developer and User Community

Transform raw table column having JSON as Object type to Data Model

Hi, I want to transform JSON object to Data model column. JSON is populated from extractor to raw table, so its type is by default Object and its structure will be nested.Is there any built-in/ Custom function using which I can parse this json  and convert the specific value into column. I have tried to_josn () which will convert the json structure to string and then with the help of get_json_object() I can get expected value by passing json path to this function. But problem here is it will always return value as String.  

7
C
6 months ago
A
Active
Akshay HandeActive
asked in Developer and User Community

Create raw table with only column names

I wanted to know, can I create a Table in RAW database, which will contain only column names initially with 0 rows added in it?

1
Murad Sæter
Practitioner
8 months ago

Badge winners

Show all badges
Terms & ConditionsCookie Settings