René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"FAQPage","mainEntity":[{"@type":"Question","name":"When should I use query preview mode instead of DataFrame mode?","acceptedAnswer":{"@type":"Answer","text":"Use query preview mode when you want to defer from pulling data into memory or when you are building complex SQL queries that you want to test in iterations. Use DataFrame mode when you want to process the full results of a query at once."}},{"@type":"Question","name":"Can I reference DataFrame variables in SQL blocks?","acceptedAnswer":{"@type":"Answer","text":"No, you cannot reference DataFrame variables in SQL blocks. You can only reference query preview objects."}},{"@type":"Question","name":"Can I use query preview mode with DataFrame SQL blocks?","acceptedAnswer":{"@type":"Answer","text":"Yes! even though you are querying a DataFrame, you may want to retrieve only a subset of the data and reference the query later."}},{"@type":"Question","name":"Can I use query preview objects in other blocks?","acceptedAnswer":{"@type":"Answer","text":"Yes, you can use query previews exactly as you would use a DataFrame. Actually, the DeepnoteQueryPreview object that is returned is a subclass of a Pandas DataFrame. This means you can also plot it in a Chart block. However, do keep in mind that the preview only contains first 100 rows.\n\nSQL using DeepnoteQueryPreview"}}]}