Yes, you can change the datatype of the columns imported into Zoho Analytics. Can I change the data-type of the columns imported in Zoho Analytics? Click here to learn about the Look-up column feature. However, you can manually link the tables in Zoho Analytics using the Look-up column feature. If you import data from one table at a time (choosing single table option) then the foreign keys will not be defined. The foreign keys will be created as Look-up columns in Zoho Analytics. When importing multiple tables, the foreign keys defined between the tables in Google Cloud SQL PostgreSQL database will be linked in Zoho Analytics. Will foreign keys defined between my tables in Google Cloud SQL PostgreSQL database be linked in Zoho Analytics as well? Yes, you can import data from both Views and Tables into Zoho Analytics. Can I import data from Views created in Google Cloud SQL PostgreSQL (apart from Tables) into Zoho Analytics? Preamble: Why should I allowlist Zoho Analytics IP addresses and How do I do it? What are the limitations of Google Cloud SQL PostgreSQL Live Connect?ĭata Import 1.What happens when I delete or rename the database in Google Cloud SQL PostgreSQL?.Can I create Query Tables over the Google Cloud SQL PostgreSQL data?.Can I import data from other data sources into the same workspace that I have used to connect with Google Cloud SQL PostgreSQL?.Can I connect the new columns added in my Google Cloud SQL PostgreSQL database to Zoho Analytics?.When do Mismatches occur and how to resolve them?.I got an alert message "This view cannot be accessed due to some changes made in the table" while accessing my tables/reports in Zoho Analytics.Can I connect Views created in Google Cloud SQL PostgreSQL (apart from Tables) to Zoho Analytics?.Will the reports/dashboards query hit my database server every time I open it or can it be cached in Zoho Analytics?.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |