I know we can have snowflake to run SQL queries but can we have complex SQL that will used to generate a chart or number?
Also, do we have flexibility to add UI controls (dropdown, label, etc) like we have in Google Data Studio?
Hey imranku07
There is an Amplitude Query add-on which allows customers to write custom SQL against their Amplitude data directly inside the Amplitude platform. You can try this one if you want to run your SQL queries inside Amplitude UI and generate the charts accordingly as shown in the doc.As of today, there isn’t much flexibility in the charts for adding custom UI controls that you mentioned. Amplitude isn’t a full fledged custom data viz platform yet as compared to tools like Google Data Studio. There is some level of customization you can do while creating dashboards and templates, but I don’t think that’s what you are looking for here.
Hope this helps.
I am running into a loop when attempting to import data from BigQuery. At origin, my data is already in milliseconds since epoch. If I query: event_time as time, I get the error: 1.'time' column should be a TIMESTAMP_NTZ column (Snowflake) or a TIMESTAMP column (BigQuery). example for the type of 'time' column is…
How do I transfer data from one amplitude account to another? It seems all the community chats about this have completely broken links. Easy to export, no way to import, very frustrating. :(
When using @amplitude/plugin-web-vitals-browser with Create React App v4 (react-scripts@4.0.3), the build fails with: ./node_modules/@amplitude/plugin-web-vitals-browser/node_modules/web-vitals/dist/web-vitals.js<br /><br />SyntaxError:…
Hello, I'm using SpringBoot and Kotlin to integrate with the Amplitude Export API. The official Amplitude documentation (https://amplitude.com/docs/apis/analytics/export) states that "data is available to export at a minimum within 2 hours of when the servers received it." However, there's no clear information about the…
Hello, Is there a way to make a query like: “Give me all the users that have the user property X equal to 10”, by using just any of the APIs, without making a cohort first through the Amplitude’s UI? Thank you!
