![metabase integrations metabase integrations](https://cdn.holistics.io/landing/compare/holistics-v-metabase.png)
The code in this article should be a good starting point for you to learn and explore other API functions. There are also many other API calls available in Metabase we did not cover. With this method, we can have all our queries in the Python script and we know exactly what we are querying. I prefer querying directly from the database with a user-defined query using Metabase rest API.
![metabase integrations metabase integrations](https://www.knowi.com/wp-content/uploads/2020/02/metabase@2x.png)
From daily to-do’s to company goals, with Asana teams know what work matters and what it takes to get it done. Here I showed you three ways to query data from Metabase: query from the card using Metabase rest API, query directly from the database with a user-defined query using Metabase rest API, and query from the card using a Python API metabasepy. Communicate, collaborate, and coordinate work in Asana. Apache Spark, Amazon Redshift, Google BigQuery, Tableau, and Metabase are the most. But you are certainly welcome to try it out. Azure Synapse Integration Guides and Tutorials A list of guides and. I feel like the Python API is less flexible. Google Analytics & Tag Manager) and other common applications (integrations, heat mapping, a/b testing, chat, personalization, analytics, ABM, etc.). Similar to the Query card section we mentioned above, here we can query card 1 with the following code: from metabasepy import Client, MetabaseTableParser cli = Client(username=username, password=password, base_url=endpoint) cli.authenticate() query_response = (card_id="1") data_table = MetabaseTableParser.get_table(metabase_response=query_response) df = pd.DataFrame(data_table._dict_) df I also tried out a Python API metabasepy. Now you should be able to see the results of your query in df.