Snowflake Client by SQLPro
Database Client for Snowflake
Only for Mac
Free · In‑App Purchases
SQLPro for Snowflake is a advanced but lightweight Snowflake database client, allowing quick and simple access to Snowflake servers.
Features include:
+ Syntax highlighting.
+ Intellisense.
+ Tabbed based interface.
+ Support for executing multiple queries at once.
+ Quick access to tables, columns and more.
Please note:
This SQL Client does NOT work with other database servers such as MySQL, Postgres or Microsoft SQL Server. If you are looking for multi-client support, please download SQLPro Studio.
Privacy Policy:
https://hankinsoft.com/privacypolicy.html
Terms of Use:
https://hankinsoft.com/termsofuse.html
Price:
SQLPro requires a Premium upgrade in order to interact with database result sets. Premium is available as either a Lifetime Purchase or through a Subscription with Monthly and Yearly options. Subscriptions auto-renew within 24 hours of the expiration date unless auto-renewal is turned off in the iTunes account settings. Your Account will be charged for renewal (based on your selected plan) within 24-hours prior to the end of the current period. Any unused portion of a free trial period, if offered, will be forfeited when the user purchases a subscription to that publication, where applicable. Payment will be charged to your iTunes Account at confirmation of purchase.
more My org uses SSO for snowflake login and other apps like DBeaver user 'externalbrowser' authentication for getting connected. SQLPro doesn't have this yet and I can't login as I don't have a snowflake specific password.
My org uses SSO for snowflake login and other apps like DBeaver user 'externalbrowser' authentication for getting connected. SQLPro doesn't have this yet and I can't login as I don't have a snowflake specific password.
Not for anyone that would need SSO authentication to signon
Not for anyone that would need SSO authentication to signon
+ Performance improvements with the query editor.
+ Crash fix related to the query editor.
2024.15 02/20/2024
+ Fixed an issue which could cause a crash for some users.
2022.23 04/30/2022
+ Fixed a crash some users could see when restoring app state.
2021.64 06/20/2021
+ Fixed the app icon. It was slightly larger than it should be. [#627](https://github.com/hankinsoft/SQLPro/issues/627)
+ Fixed an issue where table detection may detect the wrong table if a comment proceeded the query. [#650](https://github.com/hankinsoft/SQLPro/issues/650)
+ Added autocomplete/syntax highlight support for additional Snowflake functions. [#655](https://github.com/hankinsoft/SQLPro/issues/655)
+ Fixed a crash that some users were seeing when exporting results.
+ Fixed a crash that some users were seeing when hitting 'Apply without preview' when editing results.
2021.63 06/19/2021
+ macOS 10.12 or above is now the minimum version supported.
+ Fixed a crash which could occur when running large queries. [#514](https://github.com/hankinsoft/SQLPro/issues/514)
+ Importing a CSV file now has the option to truncate the target table before importing. [#511](https://github.com/hankinsoft/SQLPro/issues/511)
+ Autocomplete with Functions and Keywords will now always default to uppercase.
+ Fixed a keyboard shortcut issue when using Dvorak layout.
+ Multi cursor improvements with arrow up/down cursor selection.
+ Fixed an issue with query line numbers display.
+ Fixed a crash that could occur on the connections list window.
+ Fixed an issue that could cause a crash when inserting/duplicating rows, deleting rows, then cancelling actions together on the results grid.
+ Added the common enter/exit full-screen keyboard shortcut. [#497](https://github.com/hankinsoft/SQLPro/issues/497).
+ Added some missing Snowflake keywords and functions. [#495](https://github.com/hankinsoft/SQLPro/issues/495) + [492](https://github.com/hankinsoft/SQLPro/issues/492)
+ Multi-cursor improvements. Cmd+Delete and Opt+Delete now work properly.
+ Keyboard support added for selecting multi-cursors. Cmd+Option+Up/Down arrows.
+ Fixed a few crashes which could occur with multi-cursors.
+ Improved pasting with multi-cursors.
+ Fixed an issue when inserting rows where the string 'default' could sometimes be used rather than the default value.
+ You can now rename a MySQL column from the database tree, by right clicking the column name and choosing 'Rename'.
+ When connecting to MySQL or MSSQL server with an expired password, you can now set a password.
+ Some improvements with the autocomplete cache.
+ Fixed an issue where when creating tables, the database tree UI may show garbage values for the table name.
+ Fixed an issue with shift + click to select text.
+ Sorting results from a 'basic select' will now use the database server to perform the sort. [#381](https://github.com/hankinsoft/SQLPro/issues/381)
+ Fixed a crash which could occur when right clicking a result and choosing 'edit'.
+ Fixed an issue where pasting was sometimes using overwrite rather than insert. [#483](https://github.com/hankinsoft/SQLPro/issues/483)
+ Multicursor support. [#200](https://github.com/hankinsoft/SQLPro/issues/200)
+ You can now 'reverse-cycle' the autocomplete window. [#473](https://github.com/hankinsoft/SQLPro/issues/473)
+ Working on resolving an issue where the cursor position might jump when autocomplete is entered. [#476](https://github.com/hankinsoft/SQLPro/issues/476)
+ Autocomplete delay has been reset to the default (1.25 seconds). Due to a bug which had caused some users autocomplete to set to zero.
+ Adding or removing tables via the query editor (ie CREATE TABLE/DROP TABLE) will now update the database tree and autocomplete. [#10](https://github.com/hankinsoft/SQLPro/issues/10)
+ Autocomplete now wraps when using up/down keys. [#473](https://github.com/hankinsoft/SQLPro/issues/473)
+ Selected rows in the results grid now highlight the row numbers. [#465](https://github.com/hankinsoft/SQLPro/issues/465)
+ Added COALESCE keyword. [#469](https://github.com/hankinsoft/SQLPro/issues/469)
+ Adding/removing/altering a table will now update the database tree and autocomplete. [#10](https://github.com/hankinsoft/SQLPro/issues/10)
+ Fixed insertion text for CTEs and aliases. [#296](https://github.com/hankinsoft/SQLPro/issues/296)
+ Snowflake will now display // as single line comments. [#456](https://github.com/hankinsoft/SQLPro/issues/456)
+ Database names colors are now customizable for the query editor. [#404](https://github.com/hankinsoft/SQLPro/issues/404)
+ Made some attempts at fixing autocomplete window sometimes appearing in the incorrect location. [#377](https://github.com/hankinsoft/SQLPro/issues/377)
+ Autocomplete delay now has a preference. [#394](https://github.com/hankinsoft/SQLPro/issues/394)
+ Fixed a crash some MSSQL users would see.
2020.96 11/10/2020
+ Improvements with cancelling snowflake queries.
+ Fix for Snowflake not displaying proper affected rows. [#407](https://github.com/hankinsoft/SQLPro/issues/407)
+ Fixed an issue with signed integers being treated as unsigned. [#410](https://github.com/hankinsoft/SQLPro/issues/410)
2020.42 05/08/2020
+ Performance improvements for autocomplete.
+ Fixed a crash which could occur with autocomplete.
+ 'Execute button' now has additional options.
+ Performance improvements for autocomplete.
+ Improvements to state restore where not all tabs were always being restored.
+ Result grid editing - Primary keys are no longer required (but are still encouraged).
+ Result grid editing - When editing cells, changes are no longer applied until the new 'Preview and Apply' button has been pressed. A discard button is also available.
+ Result grid editing - Shift-Tab now works to move to the previous cell (and regular tab now works better due to the previously mentioned change).
+ Improved background drawing in query text view when query execution style is 'execute query in cursor range'.
+ Quoted column names are now handled by syntax highlighting.
+ Creating a table in Postgres no longer displays as reversed schema/table name.
+ Fixed an issue where the 'databases' dropdown in the new/edit connection window could cause a crash.
+ Fixed an issue with could sometimes cause crashes when typing a query.
+ Fixed multiple issues with state restoration.
+ Many buttons now respect the systems accent color (macOS 10.14 and above).
+ Fixed an issue where CTE columns may display incorrect column names. [#314](https://github.com/hankinsoft/SQLPro/issues/314)
+ Fixed an issue autocomplete window may display below the bottom of the screen. [#315](https://github.com/hankinsoft/SQLPro/issues/315)
+ Postgres table designer now supports Table comments. [#313](https://github.com/hankinsoft/SQLPro/issues/313)
+ CTEs and Aliases are now highlighted in the query editor (there is a limitation on the maximum query length before this gets disabled).
+ Fix for a crash that could occur with autocomplete [317](https://github.com/hankinsoft/SQLPro/issues/317)
+ Fixed an issue with expand/collapse database tree sidebar (when search tab was selected) which could mess up the UI.
+ Fixed a crash that could occur when right clicking on some database tree nodes and choosing 'refresh'.
+ Fixed a few improvements with state restoration.
+ Improved performance with the search scope selector.
+ Fixed an issue where right clicking on the 'messages results' (contains text such as 'query finished successfully') could cause crashes.
+ Fixed an issue where some MySQL errors would not be displayed to the user.
+ Fixed a performance issue with the connection dialog on macOS 10.13 and before.
+ Fixed searching not working.
+ Fixed an issue you could sometimes not insert into a table from result sets. (Inserting from a result set still requires a 'simple query'). [#312](https://github.com/hankinsoft/SQLPro/issues/312)
+ Added advanced searching. [#180](https://github.com/hankinsoft/SQLPro/issues/180)
+ You can now right click on a table name in the query editor and perform a few actions such as 'select first 1,000 rows', 'script as create statement', 'script as drop and create statement' and 'script as drop statement'. This also works on aliases.
+ Fixed an issue where entering/exiting full screen could be slow.
+ Autocomplete now includes partial matches as well as full matches.
+ Autocomplete is now context sensitive. For example, if you enter `SELECT * FROM myTable WHERE ` autocomplete will suggest myTable and columns related to myTable.
+ Boolean fields now appear with color (green for true, red for false - this is a preference which can be disabled).
+ Boolean fields now display as true/false rather than 1/0 (this is a preference which can be disabled).
+ Autocomplete now includes partial word matches.
+ CTEs are now included in autocomplete.
2019.59 11/25/2019
+ Fixed an issue where NULLs appear as 0.
+ Fixed a connection issue (some users were seeing SSL error messages).
+ Fixed an issue with over aggressive object name escaping.
2019.09.06 09/07/2019
+ Performance improvements with the query editor.
+ Crash fix related to the query editor.
more Version 2024.15 02/20/2024
Data Not Linked to You The following data may be collected but it is not linked to your identity:
