Querying Data
This section provides information about the Lyftrondata connector query maker method and how to execute ANSI Sql queries
Executing Query
The Lyftrondata driver for Eventbrite provides query maker functionality for querying data. To execute SQL statements that return data, use the cursor object's execute method. Once a query is executed, the result set is fetched from the API. This result set is converted into the relational format and returned which can then be printed out.
Querying with where clause
We can filter our data directly from the API by providing a where clause for the table.
Querying Sys & Data Tables
The connector possesses system table definition that provides information about the connector framework metadata, and data tables that are used to discover the connector business information in the [ERD Data Model](../../../Sales Analytics/eventbrite/data-model/erd.md).
Querying Sys Views
The connector possesses views definition that provides information about how these views are used to discover the connector business information in the [ERD Data Model](../../../Sales Analytics/eventbrite/data-model/erd.md).
Usage Logging
You will simply need to set two connection properties to begin capturing provider logging.
For the usage logging you have to execute a query "select * from sys.usage", which will return all the usage of the connector from the beginning.
It shows how much time left, time spent and total allotted time of the connector.
You can also access the timestamp.txt from the current driver directory which contains information, such as when authentication is performed or queries are executed. The specified file will be created by the driver in your working directory.
Quickstart Steps
Do you have questions about how to use the platform? Don't worry; we've got you covered. Simply follow the quickstart instructions here.
Questions?
We're always happy to answer any additional questions you may have! Set up a meeting with our data experts.
Last updated