Data - Get External Data - Open Query from File

Ribbon bar. Select the Data tab. In the Manage group, click External Data and from the menu, select Open Query from File; or, select the File tab. In the left pane, click External Data and in the right pane under Query, click Open...

Classic menus. From the Data - Get External Data submenu (or the File - Get External Data submenu), select Open Query from File... display the standard Open dialog box in which you can select an SQL file to run. Note that *.sqy files are (created and) saved in Statistica Query (via the File - Save As command).

Note: Connecting to external databases for streaming. The Get External Data option executes a user-defined query, and copies the resulting data to your local computer. In other words, all data retrieved by the query will be copied into a Statistica data file, and stored locally. Alternatively, you can connect to external databases and retrieve particular sets of data via query without the need to create a local copy of the data. Specifically, in the Create New Document dialog box, select the Streaming DB Connector tab to create a connection to a database that will look to Statistica as if it were a regular data file. In other words, when you use the streaming options, the program will not first copy and store all data returned by the query on your local computer and then begin the analyses, but rather, the computer will process the database in place, only fetching the information from the database when it is needed for computations. Hence, streaming connections are particularly useful and efficient when processing extremely large data sets (retrieved by a query from an external database), and they are commonly used in data mining applications. See also Streaming Database Connector Technology for additional details.