Metadata Json on the GPT Store
By Alejandro MorenoShow 1+ GPTs by Alejandro Moreno
GPT Description
Crea JSON de Metadato
GPT Prompt Starters
- te voy a exlicar el caso de uso que llevo entre manos, el caso es que tengo una estructura de tablas del metadato en snowflake que se formatea mediante archivos .json el caso es que tengo que hacer un monton y quiero que me ayudes. Este archivo es un ejemplo del metadato de una tabla { "OBJECT_ID": 1004, "MODEL_ID": 2, "TARGET_ID": 2, "BLOB_ID": 1, "SOURCE_ID": 10, "OBJECT_NAME": "DB2_DIM_F_AFSUSR", "SOURCE_JSON_DEFINITION": { "des_source_schema": "DATEXP", "des_source_table": "AFSUSR", "des_source_query": "", "des_source_modified_from": "[$]{yyyymmdd_desde_gen}", "des_source_modified_to": "${yyyymmdd_desde_gen}", "des_source_gen_delta": "False", "des_source_from_lookup": "[$]{DDMMYY_HHMI_desde_gen}", "des_source_to_lookup": "${DDMMYY_HHMI_desde_gen}" }, "BLOB_JSON_DEFINITION": { "des_blob_columndelimiter": ";", "des_blob_container": "intermediate", "des_blob_directory": "DBUNIGEST/DB2/AFSUSR", "des_blob_file": "${yyyymmddhhmmssfff_desde_gen}AFSUSR.csv", "des_blob_quotecharacter": "", "des_blob_encoding":"UTF-8", "des_blob_header":"true" }, "TARGET_JSON_DEFINITION": { "des_target_database": "DB_UVANALYTICS_EDWH_DEV", "des_target_expression_order": "", "des_target_fields": [ { "name": "ID", "pk": "false", "type": "NVARCHAR(200)" } ], "des_target_filter": "NO FILTER", "des_target_load_type": "UPSERT", "des_target_schema": "STAGGING", "des_target_table": "AFSUSR" }, "OBJECT_JSON_DEFINITION": { "des_obj_backwards_qty": "null", "des_obj_timezone": "Europe/Madrid", "transformation":"False" }, "OBJECT_FLAG_ACTIVE": "True" }
Metadata Json GPT FAQs
Currently, access to this GPT requires a ChatGPT Plus subscription.
Visit the largest GPT directory GPTsHunter.com, search to find the current GPT: "Metadata Json", click the button on the GPT detail page to navigate to the GPT Store. Follow the instructions to enter your detailed question and wait for the GPT to return an answer. Enjoy!
We are currently calculating its ranking on the GPT Store. Please check back later for updates.
