Columns: A list of all the columns in a selected table.Click the play button next to any table name to quickly return a sampling of 100 rows from that table. Tables: All the tables that you have access to for a given data connection are listed here, organized by schema.To pin a table, hover over its name and click the pin icon on the right. Tables are automatically pinned as you query them. Pinned: Tables you "pin" are shown at the top of the schema browser so you can easily find them.Search: Type to search for table names in the selected database.The query will also execute against this connection. The schema browser will show tables for the database displayed here. Selected data connection: Click to reveal and select from a list of data connections.Show/hide: Click to hide or reveal the schema browser.The schema browser lets you explore the schemas, tables and columns in the selected database. Schema Browser: A visual representation of the schemas, tables and columns that are available in the selected database.Database dropdown: Tells Mode which connection to query and which database's schemas and tables to display in the schema browser.TIP: Quickly expand or collapse the Data View by double clicking its header Use the Source tab to toggle between the raw and rendered SQL that was executed at the time of the run, and copy the syntax to the clipboard.Use the Fields tab to view meta-data about your fields, add new Calculated fields, and edit, rename, or remove existing Calculated fields.Use the Data tab to consume your results, share the URL to that specific query, export the raw query data as a CSV, or copy the data to the clipboard.To turn autocomplete on or off, you can toggle the switch in the Autocomplete Settings or you can disable (and re-enable) it by hitting CMD + Option + a (Control + ALT + a on a PC) in the editor.ĭata view: After you successfully execute a SQL query, the tabular results, fields, and syntax are displayed here. Choose between light and dark modes, side-by-side or stacked panels, Limit 100 on/off by default, and other helpful autocomplete settings. These options allow you to personalize the editor to fit your preferences. Psequel cancel a query code#Editor Settings: Toggle on/off settings for the code editor. Select a historical query run and click Open to replace the code currently in the query editor with the code from that run.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |