BlueJay3003 - Anyone knows why I would get "Inv...
Anyone knows why I would get "Invalid YAML/JSON syntax in file." while importing back file as is that was downloaded via Validate connection option? The file has few metadata updates I am trying to apply from underlying Redshift.
6 Replies
Could this be the issue you are facing? https://developers.thoughtspot.com/docs/tml#yamlReimport
TML
The TML API endpoints allow you to export and import TML files
{
"hasChanges": true,
"tableDiffs": [
{
"externalTableName": {
"databaseName": "db",
"schemaName": "dd",
"tableName": "table1",
"gid": 0
},
"logicalTableName": "table1",
"externalTableDeleted": true,
"columnDiffs": []
},
{
"externalTableName": {
"databaseName": "db",
"schemaName": "db",
"tableName": "table2",
"gid": 0
},
"logicalTableName": "table2",
"externalTableDeleted": false,
"columnDiffs": [
{
"columnName": "col1",
"externalColumnName": "col1",
"columnDelta": {
"changeType": "ADDED",
"newDatatype": "VARCHAR"
}
}
]
}
]
}
that's essentially the file content
could it be that TML import can't handle JSON file even though that's the only way to import this metadata diff?
TML Editor just shows "A system error has occurred." when open that file and validate there
Are you using the API or using the TS UI?
TS UI, both for export and import
Can you create a support ticket for this? The relevant team should be able to help you out
I did.