| |
| Date | Build
Number | Change
Type | Description |
| 10/06/2025 | 9410 | General | Added
- Support for parsing datetime formats using ".S" and ",S" for milliseconds and nanoseconds.
|
| 09/12/2025 | 9386 | General | Added
- Added the IsInsertable, IsUpdateable, and IsDeleteable columns to the sys_tables table.
|
| 09/10/2025 | 9384 | General | Changed
- All columns in statically defined Views are now reported as read-only.
|
| 09/03/2025 | 9377 | General | Changed
- Corrected the behavior when IN criteria with NULL values are used in the projection part. It now returns NULL instead of 0. For example, "NULL IN (1,2)" returns "NULL".
|
| 09/01/2025 | 9375 | General | Added
- Added support for using the CAST function with infinity values. This function can cast "inf" and "-inf" to DOUBLE, FLOAT, or REAL.
|
| 08/21/2025 | 9364 | General | Changed
- Report behavior change:
- Fixed inconsistent string value comparisons in non-table queries.
- For example, "SELECT 'A' = 'a'" previously returned false, but it now returns true.
|
| 08/13/2025 | 9356 | General | Changed
- Changed the maximum number of pages held in memory from 15 to 5 for the page providers to decrease heap usage.
|
| 06/25/2025 | 9307 | General | Removed
- Removed the "ADLS Gen 1" value from the ConnectionType property.
|
| 06/20/2025 | 9302 | General | Added
- Created the following functions:
- TEXT_ENCODE: encodes a string into a different charset (UTF8 → UTF7 and returns a binary array as the result).
- TEXT_DECODE: takes a binary array and decodes it back into a string when provided the charset.
- BASE64_ENCODE: takes a binary array and encodes it as a base64 string (varchar).
- BASE64_DECODE: takes a base 64-encoded string and decodes it into a binary array.
|
| 06/19/2025 | 9301 | Smartsheet | Removed
- Removed the Info_Shares view.
|
| 06/18/2025 | 9300 | General | Changed
- The internal code for exception handling has been refactored. Exception messages returned during certain error conditions may now have different wording or formatting.
|
| 06/16/2025 | 9298 | Smartsheet | Added
- Added Description column to the Info_Attachments table.
- Added MemberEmails column to the Info_Groups table.
- Added support for DELETE statements in the Info_Discussions table.
- Added support for INSERT, UPDATE, and DELETE statements in the Info_Groups table.
- Added Info_AttachmentVersions view for reading data on attachment versions.
- Added UploadAttachmentVersion stored procedure for re-uploading file attachments.
- Added DeleteAllVersions input to the DeleteAttachment stored procedure for deleting all versions of the
Removed
- Removed FilePath and ContentEncoded columns from the Info_Attachments table.
- Removed support for uploading/creating file attachments through INSERT statements in the Info_Attachments table. Exposed a new UploadAttachment stored procedure for this functionality instead.
|
| 05/27/2025 | 9278 | General | Removed
- Removed the "Proprietary" enum option from ProxyAuthscheme.
|
| 05/09/2025 | 9260 | Smartsheet | Added
- Added the blank, categories, globalTemplate, largeImage, tags, and scope columns to the Info_Templates table.
|
| 05/07/2025 | 9258 | Smartsheet | Added
- Added support for UPDATE and DELETE statements to the Info_Comments table.
|
| 05/06/2025 | 9257 | Smartsheet | Added
- Added to the Info_Folders view two new columns: CreatedAt and ModifiedAt. These columns only display when UseLegacyAPI=False.
- Added two new views: Info_Dashboards (which represents the dashboards created in the Smartsheet account) and Info_DashboardShares (which represents the sharing operations of the dashboard entities).
|
| 05/05/2025 | 9256 | Smartsheet | Added
- Added three new views to expose the publish status details of Dashboards, Reports, and Sheets.
|
| 04/29/2025 | 9250 | Smartsheet | Added
- Added a new connection property, UseLegacyAPI. Setting this property enables users to switch between the old metadata retrieval logic (UseLegacyAPI=true, default behavior) which uses the Home API (deprecated) endpoint, and the new metadata retrieval logic, where more recent APIs are used.
- Added a new column: Info_Folders.ParentFolderId.
- Added a RootFolderId pseudo-column to the following tables: Info_Folders, Info_Sheets, Info_Reports and Info_Templates. This pseudo-column displays when the UseLegacyAPI configuration parameter is set to False.
|
| 04/08/2025 | 9229 | Smartsheet | Added
- Added the following views: Info_SheetShares, Info_ReportShares, and Info_WorkspaceShares.
|
| 02/15/2025 | 9177 | General | Added
- Added support for converting unsigned integer types to the nearest signed data type that has enough precision to hold the unsigned value.This is done for JDBC only because it does not have support for unsigned data types.
|
| 01/27/2025 | 9158 | Smartsheet | Added
- Added validations for data definition language (DDL) statements. A RowId column with the exact definition RowId VARCHAR PRIMARY KEY is required in CREATE TABLE statements. Only the column name and data type are supported for other columns, such as Column1 VARCHAR.
- Added validation for ALTER TABLE statements so the RowId column cannot be modified in any way.
|
| 12/30/2024 | 9130 | Smartsheet | Added
- Added the UseIdAsTableName connection property. This property determines whether the provider uses IDs instead of sheet and report names as table identifiers.
|
| 11/27/2024 | 9097 | General | Added
- Added ThreadId to LogModule output. Logfile lines now include the Thread ID associated with the action being performed.
|
| 05/09/2024 | 8895 | General | Changed
- The ROUND function previously did not accept negative precision values. That feature has now been restored.
|
| 03/15/2024 | 8840 | General | Added
- Created a new SQL function called STRING_COMPARE that provides java's String.compare() ability to SQL queries. Returns a number representative of the compared value of two strings
|
| 11/29/2023 | 8733 | General | Changed
- The ROUND function doesn't accept the negative precision values anymore.
Changed
- The returning types of the FDMonth, FDQuarter, FDWeek, LDMonth, LDQuarter, LDWeek functions are changed from Timestamp to Date.
- The return type of the ABS function will be consistent with the parameter value type.
|
| 11/28/2023 | 8732 | General | Added
- Added the HMACSHA256 formatter to allow for secrets to be decoded if it is in base64 format
|
| 07/18/2023 | 8599 | Smartsheet | Added
- Added new columns to the Info_Users view. Due to API limitations, these are only populated when an Id filter is defined. The new columns are the following: Company, Department, MobilePhone, LastLogin, Role, Title, WorkPhone
|
| 06/20/2023 | 8571 | General | Added
- Added the new sys_lastresultinfo system table.
|
| 06/08/2023 | 8559 | Smartsheet | Added
- Added Region property. The property contain three values: Global the default value, EU and GOV.
|
| 05/04/2023 | 8524 | Smartsheet | Added
- Added ColumnFormat TypeDetectionScheme, which determines the datatypes based on the format specified for the column.
|
| 04/25/2023 | 8515 | General | Removed
- Removed support for the SELECT INTO CSV statement. The core code doesn't support it anymore.
|
| 12/14/2022 | 8383 | General | Changed
- Added the Default column to the sys_procedureparameters table.
|
| 11/24/2022 | 8363 | Smartsheet | Added
- Added Overwrite parameter for the ImportFile stored procedure. If the parameter is set to True the stored procedure will delete every sheet that has the same name as the one which will be uploaded.
|
| 11/11/2022 | 8350 | Smartsheet | Added
- The ValueSource property was added, allowing users to alter which field would be used by the driver to determine the value of the cell.
- Auto will use which field is not null.
- Value will use the "Value" field.
- DisplayValue will use the "DisplayValue" field.
|
| 10/12/2022 | 8320 | Tableau | Added
- Added support for additional localizations in the Windows and Mac packages. Both setups now support all the languages that Tableau supports as of their 2022.2 release.
|
| 09/30/2022 | 8308 | General | Changed
- Added the IsPath column to the sys_procedureparameters table.
|
| 09/02/2022 | 8280 | Smartsheet | Added
- Added streaming output support for DownloadAttachment. Added FileStream as an input.
- Added binary and encoded content output support for CreateSchema. Added FileStream as an input, and FileData as an output.
|
| 08/18/2022 | 8265 | Smartsheet | Added
- Added binary input support for ImportFile. Added FileName and Content (InputStream) as inputs.
|
| 08/12/2022 | 8259 | Tableau | Changed
- Updated connection dialogs to use advanced configuration information provided by drivers. This makes use of the same information as the new dialogs in other editions (like ODBC) to display only the most relevant connection properties.
- Legacy connectors have been simplified to look more like Tableau JDBC dialogs. Legacy connectors target older Tableau versions which do not support rich connection dialogs like the modern connectors do. Most connectors cannot fit within these limitations.
|
| 07/05/2022 | 8221 | Smartsheet | Added
- Added the Header connection property, which indicates whether or not the first row should be used as a column's name.
|
| 09/20/2021 | 7933 | Smartsheet | Added
- Added the MoveSheet stored procedure, which moves the specified sheet to a new location.
|
| 09/02/2021 | 7915 | General | Added
- Added support for the STRING_SPLIT table-valued function in the CROSS APPLY clause.
|
| 08/24/2021 | 7906 | Smartsheet | Changed
- The Info_comments table now only requires a SheetId instead of SheetId and DiscussionId. In other words, this table will now return all the comments of a given sheet.
|
| 08/07/2021 | 7889 | General | Changed
- Added the KeySeq column to the sys_foreignkeys table.
|
| 08/06/2021 | 7888 | General | Changed
- Added the new sys_primarykeys system table.
|
| 07/23/2021 | 7874 | General | Changed
- Updated the Literal Function Names for relative date/datetime functions. Previously, relative date/datetime functions resolved to a different value when used in the projection as opposed to the predicate. For example: SELECT LAST_MONTH() AS lm, Col FROM Table WHERE Col > LAST_MONTH(). Formerly, the two LAST_MONTH() methods would resolve to different datetimes. Now, they will match.
- As a replacement for the previous behavior, the relative date/datetime functions in the criteria may have an 'L' appended to them. For example: WHERE col > L_LAST_MONTH(). This will continue to resolve to the same values that were previously calculated in the criteria. Note that the "L_" prefix will only work in the predicate - it not available for the projection.
|
| 07/16/2021 | 7867 | Smartsheet | Added
- Added the UseFullFilePathsAsTableNames connection property, which sets whether or not to include the full file path in the name of an exposed table or view, corresponding to a sheet or report.
|
| 06/30/2021 | 7851 | Smartsheet | Added
- Added support for importing a CSV or XLSX to the top-level "sheets" folder, to a specified folder or to a specified workspace.
|
| 05/26/2021 | 7816 | Smartsheet | Added
- Added support for adding a discussion to a sheet or a row. Added support for adding a comment to a discussion. You can find examples at their respective tables in Data Model.
|
| 04/25/2021 | 7785 | General | Added
- Added support for handling client side formulas during insert / update. For example: UPDATE Table SET Col1 = CONCAT(Col1, " - ", Col2) WHERE Col2 LIKE 'A%'
|
| 04/23/2021 | 7783 | General | Changed
- Updated how display sizes are determined for varchar primary key and foreign key columns so they will match the reported length of the column.
|
| 04/16/2021 | 7776 | General | Added
- Non-conditional updates between two columns is now available to all drivers. For example: UPDATE Table SET Col1=Col2
|
| 04/16/2021 | 7776 | General | Changed
- Reduced the length to 255 for varchar primary key and foreign key columns.
Changed
- Updated index naming convention to avoid duplicates.
|
| 04/16/2021 | 7776 | General | Changed
- Updated implicit and metadata caching to improve performance and support for multiple connections. Old metadata caches are not compatible - you need to generate new metadata caches if you are currently using CacheMetadata.
|
| 04/16/2021 | 7776 | Tableau | Changed
- Improved the connection dialog configuration experience.
|
| 03/24/2021 | 7753 | Smartsheet | Changed
- Improved the way we were exposing the Personal Access Token. Now we have a new connection property (PersonalAccessToken) and a new value for the AuthScheme property (again PersonalAccessToken).
|
| 10/13/2020 | 7591 | Smartsheet | Added
- Changed metadata discovery endpoint to [/home](https://smartsheet-platform.github.io/api-docs/#list-contents) endpoint.
- Support for folder/workspace traversal. A query to info_folders, info_sheets and info_reports will return the complete list of the objects, not just of the first directory level.
- Exposing the FolderId and WorkspaceID for each object type in info_folders, info_sheets and info_reports.
|