Spotfire Ideas Portal
Add a new idea Subscribe
Status Future Consideration
Product Spotfire
Categories Information Services
Created by Guest
Created on Jan 23, 2024

RELATED IDEAS

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.


spotfire_athena...
spotfire_athena...
spotfire_athena_informationservice_sfquery_modify.png
Open full size
spotfire_athena_informationservice_sfquery_error.png
Open full size
spotfire_athena_informationservice_sfquery_modify.png spotfire_athena_informationservice_sfquery_error.png
  • Attach files
This document (including, without limitation, any product roadmap or statement of direction data) illustrates the planned testing, release and availability dates for Spotfire products and services. It is for informational purposes only and its contents are subject to change without notice. Planning to implement - generally 6-12 months out. Likely to Implement - generally means 12-18 months out. Copyright © 2014-2023 Cloud Software Group, Inc. All Rights Reserved. Cloud Software Group, Inc. ("Company") follows the EU Standard Contractual Clauses as per the Company's Data Processing Agreement. Terms of Use | Privacy Policy | Trademarks | Patents | Contact Us