Google Analytics Connector Column Type issue
Hello All,
I am having problems with the Google Analytics Connector.
The KeyCode management column of a custom dimension, which was recognized as a text type until last month, has suddenly changed to an Integer type.
Some IDs in the data still contain alphabetic characters, and I cannot resolve the ETL error.
It also displays "Could not parse as type Integer".
Reconnecting the connector again did not solve the problem.
I hope someone can advise me if they can find a solution.
Many Thanks,
Best Answer
-
You can ask your CSM to enable Magic ETL 2.0. It has a lot of nice enhancements is definitely worth moving to. Looking at your issue, it's hard to say if it will fix this issue. This seems like a bug with the connector and you might need to reach out to support@domo.com to have them look at it. You could also try creating a new connection and see if you still encounter the error.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1
Answers
-
Have you tried creating a basic ETL and using the Set Column Type tile to change the column back to text? Or if you are using Magic ETL 2.0 you can assign it right on the input dataset and then just link it to an output dataset.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1 -
I have tried a basic ETL and using the Set Column Type. But It doesn't work well.
It also displays "Could not parse as type Integer."
Below is the preview on ETL.
And, I could not find Magic ETL 2.0...
Thank you.
0 -
You can ask your CSM to enable Magic ETL 2.0. It has a lot of nice enhancements is definitely worth moving to. Looking at your issue, it's hard to say if it will fix this issue. This seems like a bug with the connector and you might need to reach out to support@domo.com to have them look at it. You could also try creating a new connection and see if you still encounter the error.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1 -
Understood.
Then I will try to contact support.
Until the issue is resolved, I will consider a manual response, such as importing the CSV output from the connector once again.
Your answer is a good answer to my question.
Thank you very much for your prompt and specific support.
1
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 293 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 96 SQL DataFlows
- 607 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 705 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive