René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Enable to get a compiled SQL query","articleBody":"## Motivation\n\nThe `query` method enables us to fetch data from the warehouse through Lightdash. That would be great to enhance the integration with other ecosystem. If the data we want to fetch is quite large which exceeds the limitation in Lightdash, we might want to use other tools. For instance, [bigframes](https://pypi.org/project/bigframes/) enables ua to deal with even a large BigQuery table or query results. If the python SDK provides a method to compile query by dimensions, metrics and other parameters, that would be very useful to enhance the Lightdash integration.\n\n```python\nquery = orders.compile_query(\n    dimensions=[orders.dimensions.xxx, orders.dimensions.xxx],\n    limit=10000000,\n)\n\n# Create a dataframe with the compiled query\nimport bigframes.pandas as bpd\n\nbq_df = bpd.read_gbq(query)\n```","author":{"url":"https://github.com/yu-iskw","@type":"Person","name":"yu-iskw"},"datePublished":"2025-03-03T07:19:31.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/5/python-sdk/issues/5"}