Forum Discussion
Solved
Error ODBC connecting to Athena data migrated from mongoldb
I created a DMS task on aws to fetch the collections as CSV files into s3 bucket, and then I using a crawler the columns were mapped on Athena table, however when I tried to use the Athena connector...
Hi jhonatanacelas ,
It sounds like the issue lies in the column names that contain the '$' symbol, which Athena does not handle well. You can try the following methods and check if they can resolve your problem:
1. Modify the info in data source with any one of the following ones:- Column Name Escaping: If your column names contain special characters like “$,” you should enclose them in double quotes when referencing them in your queries.
- Column Aliasing: For example, if you have a column named “_id,” you can alias it as “id” without the special character.
2. Reconnect to the Athena connector with modified query
3. Refresh the data
Best Regards
Hi jhonatanacelas ,
It sounds like the issue lies in the column names that contain the '$' symbol, which Athena does not handle well. You can try the following methods and check if they can resolve your problem:
1. Modify the info in data source with any one of the following ones:
- Column Name Escaping: If your column names contain special characters like “$,” you should enclose them in double quotes when referencing them in your queries.
- Column Aliasing: For example, if you have a column named “_id,” you can alias it as “id” without the special character.
2. Reconnect to the Athena connector with modified query
3. Refresh the data
Best Regards