Skip to Main Content
Spotfire Ideas Portal
Status Future Consideration
Product Spotfire
Created by Guest
Created on Jan 23, 2024

build table's alias with alphabet for information link SQL to avoid errors

We are seeing SQL error with some databases when loading data via information link.

The SQL is generated by Information Designer with table's alias being built from the first character of the table name.

In case of MongoDB (via MySQL data source templates, connect to MongoDB Connector for BI) and Amazon Athena, if tablename is in Japanese, then SQL error happens due to the alias being in Japanese.

The workaround is to manually modify the SQL and change the alias to alphabet.

We hope to have an option to build table's alias with alphabet, instead of the first character of the table name.

  • Attach files