Sales Analytics
  • Sales Analytics
    • Accelo
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Act!Crm
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Aftershiptracking
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Agilecrm
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Android
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Babelforce
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Brandwatch
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Bullhorn
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Capsule CRM
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Centriccrm
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Closeio
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Clubhouse
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Clubspeed
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Copper
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Coppercrm
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Drip
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Dynamics 365 Sales
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Eventbrite
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Freshsales
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Gorgias
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Grafana
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Harvest
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Ieyasu
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Insightly
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Launchdarkly
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Lead Desk
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Liondesk
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Logikura
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Mattermark
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Myob Advanced Business
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Netsuite Crm
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Ontraport
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Opsgenie
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Oracle Sales Cloud
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Paymo
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Pipedrive Crm
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Pipedrive
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Pipeline Deals
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Pipeliner
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Repairshopr
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Sage Crm
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Salesforce
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Sap Fieldglass
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Sap Hybris C4C
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Shipengine
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Streak
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Sugar Crm
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Suite Crm
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Taxrates
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Teamgate
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Unified
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Veeva
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Zoho Commerce
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Zoho Expense
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Zohocrm
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
Powered by GitBook
On this page
  • Executing Query
  • Querying with where clause
  • Querying Sys & Data Tables
  • Querying Sys Views
  • Usage Logging
  • Quickstart Steps
  • Questions?
  1. Sales Analytics
  2. Eventbrite
  3. Driver Framework

Querying Data

This section provides information about the Lyftrondata connector query maker method and how to execute ANSI Sql queries

PreviousInstallationNextSQL Standard

Last updated 1 year ago

Executing Query

The driver for 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.

import Lyftrondata.MyConnector.lib.Lyftrondata_MyConnector_Connector as con
lyft = con.Connect("My Lyftrondata license key")
init = lyft.initialise(username="my username",password="my password")
df = lyft.execute_query("Select * from my table")
print(df)  //my pandas dataframe

Querying with where clause

We can filter our data directly from the API by providing a where clause for the table.

import Lyftrondata.MyConnector.lib.Lyftrondata_MyConnector_Connector as con
lyft = con.Connect("My Lyftrondata license key")
init = lyft.initialise(username="my username",password="my password")
df = lyft.execute_query("Select * from my table where id=3")
print(df)  //my pandas dataframe

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).

import Lyftrondata.MyConnector.lib.Lyftrondata_MyConnector_Connector as con
lyft = con.Connect("My Lyftrondata license key")
init = lyft.initialise(username="my username",password="my password")
df = lyft.execute_query("Select * from my sys.tables")
print(df)  //my pandas dataframe

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).

import Lyftrondata.MyConnector.lib.Lyftrondata_MyConnector_Connector as con
lyft = con.Connect("My Lyftrondata license key")
init = lyft.initialise(username="my username",password="my password")
df = lyft.execute_query("Select * from my sys.views")
print(df)  //my pandas dataframe

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.

import Lyftrondata.MyConnector.lib.Lyftrondata_MyConnector_Connector as con
lyft = con.Connect("My Lyftrondata license key")
init = lyft.initialise(username="my username",password="my password")
df = lyft.execute_query("Select * from my sys.usage")
print(df)  //my pandas dataframe

Quickstart Steps

Questions?

Do you have questions about how to use the platform? Don't worry; we've got you covered. Simply follow the quickstart instructions .

We're always happy to answer any additional questions you may have!

Lyftrondata
Eventbrite
here
Set up a meeting with our data experts.