Hi, Few questions,
Best answer by Saish Redkar
Hey
As far as I understand, you will be able to get hold of your raw event data irrespective of how you send your events to Amplitude. There are several ways of querying your Amplitude event data with SQL :
Can you elaborate more on your 2nd question? Are you trying to join raw event data in an external warehouse or something you want to do inside Amplitude?
+10Hey
As far as I understand, you will be able to get hold of your raw event data irrespective of how you send your events to Amplitude. There are several ways of querying your Amplitude event data with SQL :
Can you elaborate more on your 2nd question? Are you trying to join raw event data in an external warehouse or something you want to do inside Amplitude?
+8Hi Dakkineni,
Thanks for contacting Amplitude Support! Denis here and happy to shed some light on the situation!
Can I use sql to query data in Amplitude events, the ones that are HTTP kind of events that are streamed using Segment?
At the moment, the only way to perform SQL like queries within Amplitude would be via the Query and Snowflake add-on which is available for purchase to our Growth and Enterprise customers! If you would like me to connect you to our sales team, I'd be happy to assist.
You can read a bit about this feature here: https://help.amplitude.com/hc/en-us/articles/115001902492
Otherwise, if you're able to export your data via the export API and pass it into a system that can manage SQL queries then that would work as well!
I have two events with different columns and want to join these two events into a custom event based on key columns, how can I achieve this. If I don’t do a join the event data is displayed with blanks on each side where the column doesn’t exist in the breakdown table
Would you be so kind as to elaborate on what you mean here? Have you got a few user examples to show me what you mean or a simple mock up in text? I am just not entirely sure of what you mean by joining. We do have custom events where two or more events are put under one event and where you can specify properties for them. Is this what you were looking for? if not, could you please elaborate on what you are trying to achieve? Thank you!
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. You can also create a Guest account below!
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. Want to sign up as a guest? Create a Community account.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
