This tutorial demonstrated some sample uses cases for utilizing Query Service in Jupyter notebooks. SELECT Substring(timestamp, 1, 10) AS Day,Ĭount(DISTINCT concat(enduserids._, The following query returns the hourly visitor count for a specified date: Query %%read_sql hourly_visitor -c QS_CONNECTION The notebook kernel resets but the cells will remain, re-run all the cells to continue where you had left off. In such cases, restart JupyterLab by selecting the Restart button located in the top-right corner next to the power button. When a notebook is inactive for an extended period of time, the connection between the notebook and Query Service may break. Successful query results or error logs are displayed below the executed cell. Execute a query by selecting on its cell followed by selecting the play button. When doing so, be sure to execute the variables cell for the changes to be applied.Įnter the following SQL queries in individual notebook cells.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |