...
From the hover menu from a database collector on a Using the Model ViewWindow, clicking creates a new Stream with the attributes implied by the query. If the Datasource Instance Expression has been entered then the expression will be used to select the datasource, otherwise the first Datasource Instance alphabetically will be used. The new Stream will be shown on the modelling pane connected to this Database Collector.
...
PhixFlow wraps the query with a "where 1= 0" to avoid a long running statement.
Time Data
| Excerpt |
|---|
PhixFlow recognises date and date-time formats, but does not recognise time-only formats, for example HH:mm:ss. When a database collector loads time data, it applies the string data-type. This applies to data from MariaDB and SQL Server databases as there is no TIME data-type in Oracle DB. |