Logo
v2020.3.1

Contents:

  • Getting Started
    • Preparing Your Machine to Install SQream
    • Installing SQream
    • Executing Statements in SQream
    • Performing Basic SQream Operations
      • Running the SQream SQL Client
      • Creating Your First Table
      • Listing Tables
      • Inserting Rows
      • Running Queries
      • Deleting Rows
      • Saving Query Results to a CSV or PSV File
    • Hardware Guide
  • Installation Guides
    • Installing and Launching SQream
      • Recommended Pre-Installation Configuration
      • Installing SQream Using Binary Packages
      • Installing and Running SQream in a Docker Container
      • Installing SQream with Kubernetes
      • Installing Monit
    • Installing SQream Studio
      • Installing Prometheus Exporter
      • Installing Prometheus Using Binary Packages
      • Installing the Dashboard Data Collector
      • Installing Studio on a Stand-Alone Server
      • Installing an NGINX Proxy Over a Secure Connection
  • Data Ingestion Sources
    • Inserting Data Overview
    • Inserting Data from a CSV File
    • Inserting Data from a Parquet File
    • Inserting Data from an ORC File
    • Migrating Data from Oracle
  • Connecting to SQream
    • Client Platforms
      • Connect to SQream Using Informatica Cloud Services
      • Connect to SQream Using MicroStrategy
      • Connecting to SQream Using Pentaho Data Integration
      • Connect to SQream Using PHP
      • Connect to SQream Using Power BI Desktop
      • Connect to SQream Using R
      • Connecting to SQream Using SAP BusinessObjects
      • Connect to SQream Using SAS Viya
      • Connect to SQream Using SQL Workbench
      • Connecting to SQream Using Tableau
      • Connecting to SQream Using Talend
      • Connecting to SQream Using TIBCO Spotfire
    • Client Drivers for v2020.3.1
      • JDBC
      • Python (pysqream)
      • Node.JS
      • ODBC
        • Install and Configure ODBC on Windows
        • Install and configure ODBC on Linux
      • C++ Driver
  • External Storage Platforms
    • Inserting Data Using Amazon S3
    • Using SQream in an HDFS Environment
  • Loading and Unloading Data
  • Feature Guides
    • Compression
    • Python UDF (User-Defined Functions)
    • Workload Manager
    • Transactions
    • Concurrency and Locks
    • Concurrency and Scaling in SQream DB
  • Operational Guides
    • Access Control
      • Overview
      • Managing Roles
      • Permissions
      • Departmental Example
    • Creating or Cloning Storage Clusters
    • Foreign Tables
    • Deleting Data
    • Exporting Data
    • Logging
    • Monitoring Query Performance
    • Security
    • Saved Queries
    • Seeing System Objects as DDL
    • Optimization and Best Practices
  • SQream Acceleration Studio 5.4.3
    • Getting Started with SQream Acceleration Studio 5.4.3
    • Monitoring Workers and Services from the Dashboard
    • Executing Statements and Running Queries from the Editor
    • Viewing Logs
    • Creating, Assigning, and Managing Roles and Permissions
    • Configuring Your Instance of SQreams
  • System Architecture
    • Internals and Architecture
    • Filesystem and usage
  • Configuration Guides
    • Configuring the Spooling Feature
    • Configuring SQream
      • Configuration Levels
      • Flag Types
      • Configuration Roles
      • Modification Methods
      • Configuring Your Parameter Values
      • Command Examples
      • Showing All Flags in the Catalog Table
      • All Configurations
    • Configuration Flags
      • Administration Flags
        • Regular Administration Flags
        • Cluster Administration Flags
        • Worker Administration Flags
      • Generic Flags
        • Regular Generic Flags
        • Worker Generic Flags
    • Configuring SQream Using the Previous Configuration Method
  • Reference Guides
    • SQL statements and syntax
      • SQL Syntax Features
      • SQL Statements
      • SQL Functions
        • Built-In Scalar Functions
        • User-Defined Functions
        • Aggregate Functions
        • Window Functions
    • Catalog Reference Guide
      • Overview
      • What Information Does the Schema Contain?
      • Catalog Tables
      • Additional Tables
      • Examples
    • Command line programs
      • metadata_server
      • sqreamd
      • sqream-console
      • sqream-installer
      • server_picker
      • SqreamStorage
      • sqream sql
      • upgrade_storage
    • SQL Feature Checklist
    • Python API Reference Guide
  • Data Type Guides
    • Converting and Casting Types
    • Supported Data Types
    • Supported Casts
      • Numeric
      • Boolean
      • Integer
      • Floating Point
      • String
      • Date
  • Release Notes
    • Release Notes 2020.3
      • Release Notes 2020.3.1
      • Release Notes 2020.3
    • Release Notes 2020.2
    • Release Notes 2020.1
  • Troubleshooting
    • Remedying Slow Queries
    • Resolving Common Issues
    • Examining Logs
    • Identifying Configuration Issues
    • Lock Related Issues
    • SAS Viya Related Issues
    • Tableau Related Issues
    • Solving “Code 126” ODBC Errors
    • Log Related Issues
    • Node.js Related Issues
    • Core Dumping Related Issues
    • SQream SQL Installation Related Issues
    • Gathering Information for SQream Support
  • Glossary
SQream DB
  • »
  • Troubleshooting »
  • Tableau Related Issues

Tableau Related Issues¶

This section describes the following best practices and troubleshooting procedures when connecting to Tableau:

  • Inserting Only Required Data

  • Using Tableau’s Table Query Syntax

  • Creating a Separate Service for Tableau

  • Error Saving Large Quantities of Data as Files

  • Troubleshooting Workbook Performance Before Deploying to the Tableau Server

  • Troubleshooting Error Codes

Inserting Only Required Data¶

When using Tableau, SQream recommends using only data that you need, as described below:

  • Insert only the data sources you need into Tableau, excluding tables that don’t require analysis.

  • To increase query performance, add filters before analyzing. Every modification you make while analyzing data queries the SQream database, sometimes several times. Adding filters to the datasource before exploring limits the amount of data analyze and increases query performance.

Using Tableau’s Table Query Syntax¶

Dragging your desired tables into the main area in Tableau builds queries based on its own syntax. This helps ensure increased performance, while using views or custom SQL may degrade performance. In addition, SQream recommends using the CREATE VIEW to create pre-optimized views, which your datasources point to.

Creating a Separate Service for Tableau¶

SQream recommends creating a separate service for Tableau with the DWLM. This reduces the impact that Tableau has on other applications and processes, such as ETL. In addition, this works in conjunction with the load balancer to ensure good performance.

Error Saving Large Quantities of Data as Files¶

An FAB9A2C5 error can when saving large quantities of data as files. If you receive this error when writing a connection string, add the fetchSize parameter to 1, as shown below:

jdbc:Sqream://<host and port>/<database name>;user=<username>;password=<password>sqream;[<optional parameters>; fetchSize=1...]

For more information on troubleshooting error FAB9A2C5, see the Tableau Knowledge Base.

Troubleshooting Workbook Performance Before Deploying to the Tableau Server¶

Tableau has a built-in performance recorder that shows how time is being spent. If you’re seeing slow performance, this could be the result of a misconfiguration such as setting concurrency too low.

Use the Tableau Performance Recorder for viewing the performance of queries run by Tableau. You can use this information to identify queries that can be optimized by using views.

Troubleshooting Error Codes¶

Tableau may be unable to locate the SQream JDBC driver. The following message is displayed when Tableau cannot locate the driver:

Error Code: 37CE01A3, No suitable driver installed or the URL is incorrect

To troubleshoot error codes:

If Tableau cannot locate the SQream JDBC driver, do the following:

  1. Verify that the JDBC driver is located in the correct directory:

  • Tableau Desktop on Windows: C:Program FilesTableauDrivers

  • Tableau Desktop on MacOS: ~/Library/Tableau/Drivers

  • Tableau on Linux: /opt/tableau/tableau_driver/jdbc

  1. Find the file path for the JDBC driver and add it to the Java classpath:

  • For Linux - export CLASSPATH=<absolute path of SQream DB JDBC driver>;$CLASSPATH

  • For Windows - add an environment variable for the classpath:

If you experience issues after restarting Tableau, see the SQream support portal.

Next Previous

© Copyright 2022 SQream. Revision 692fd83d.

SQream DB v: v2020.3.1
Versions
latest
v2022.1
v2021.2.1.24
v2021.2.1
v2021.2
v2021.1.2
v2021.1.1
v2021.1
v2020.3.2.1
v2020.3.2
v2020.3.1
v2020.3
v2020-2
v2020-1
internal_documentation
Downloads
pdf
html