How do I connect my visualization tool to Panoply.io?
You can connect any visualization tool that has an ODBC, JDBC, Postgres or AWS Redshift connections directly to Panoply.io by using the list of credentials from the top of the Analyze page.
I am already using an ETL service can I still connect to Panoply.io?
Yes, You can use the Panoply.io endpoint shown in the Analyze page of your account as the end point to use in your ETL process.
One or more of the data sources that I currently use are not in the integration dashboard, what can I do?
Panoply.io’s integration dashboard is an open source framework that allows you to upload data from any source to Panoply.io. You can upload data via our customary SDK or via any data source that has already been built an approved in the integration dashboard.
If you are using a data source that has not been built or approved yet by Panoply.io you can either, ask Panoply.io to build the data source for you or build it by yourself via the framework documentation.
What kind of files can I upload?
Panoply.io supports multiple types of files such as value separated files (CSV or TSV for example), JSONs and web distribution logs
Does Panoply.io have a recommended file size for uploading?
Currently Panoply.io supports file upload of up to 100MB. If your file weighs more than that you can upload it first to one of the supported files systems.
How do I upload a CSV file?
In the data sources screen, you should add a new data source and pick the file upload option. Then choose your file and set the destination table to send the data to (The table doesn’t have to exist at this stage). Once this is set press upload to upload the file and then press collect.
Can I schedule data sources?
You can schedule any data source except for file uploads or the SDK. Each data source can be scheduled to run as frequently as every day and every hour.
I'm using Stitch and it created multiple schemas. How can I access this data?
When using multiple schemas data warehouse, you should state the schema name before the table name when querying the data. For example, if there’s a table name “io” in a schema named “Panoply” then you can query it with the following query: select * from Panoply.io
Does Panoply.io support real-time data ingestion and queries?
Yes, you can use one of Panoply.io’s SDKs to send data in real time and every query that you will run over the data warehouse will be calculated based on the most updated data there.
My data source run failed. What should I do?
If the error that caused the data source to fail is a retriable error, then Panoply.io will retry to run it again within an hour (up to 3 retries). You can always check the Jobs screen to see the status of current and past data sources runs. If one of them failed it will be marked as error.
How do I create transformations?
Through the Workbench you can type in you desired SQL query and once completed press on the 3 dots menu button and select Save. By saving your transformation it will be available for future use and in any visualization tool you will connect.
How can I run queries on top of Panoply.io?
You can either use the internal workbench included in the platform or use any visualization tool (including external workbenches) with the credentials given in the Analyze page.
How much does Panoply Cost?
Panoply.io pricing is based on the amount of data stored. Panoply.io has multi-tier storage capabilities and therefore enables storage optimization for price and performance. The Pricing is predicated upon a Tier based subscription which consists of small business packages all the way up to enterprise packages for volume. To request a list of pricing tiers which it your needs, please email us to firstname.lastname@example.org
When I first log in, what kind of performance should I be expecting?
Panoply.io is a self-optimizing analytics infrastructure, as you initially ingest your data the platform has no knowledge of your specific analytical needs. The initial performance you would receive would be that of an unoptimized AWS Redshift cluster. You are encouraged to analyze the data as soon as possible with your initial integration, as the platform learns your business logic it will rebuild your schema in an agile way to enhance performance.
Initial performance optimization will occur within 3 days of initial analysis and within 2 weeks the schema should be optimized towards optimal performance. If the performance you are receiving is less than expected please make sure to contact your account’s data architect or, if one has not been appointed to you contact Panoply.io via the bottom right chat box or set up a demo.
I have some questions about specific features, who should I contact?
Each account has a dedicated data architect, if you do know know who your data architect is it might be because you are still in trial or have not set up a demo. If you do not know the contact information of your data architect, contact Panoply.io via the bottom right chat box or set up a demo.
How much would it cost if I would ask Panoply to build me an integration to a data source?
Panoply.io’s integration dashboard is an open source framework therefore you can build data connectors by yourself at no cost. In the case that you would need a specific data source Panoply.io will build the data source at no extra cost upon signing of the order form. In the case where a data source would be needed to evaluate the platform Panoply.io can build the data source for a one time fixed fee per data source. For Pricing of customary data sources during the evaluation period please contact Panoply.io via the bottom right chat box or set up a demo.
Can The Data Architect help me with archiving data or performance enhancement?
Yes. Panoply self-optimizes itself towards your needs by learning your specific business logic. As new data sets are integrated, data is augmented or new business logic is introduced, Panoply may take some time to optimize towards the new functions. If you need enhancements of these processes a data architect can help expedite them inside the platform.
How many seats are included per pricing tier?
The Pricing is a tier based subscription starting at only $250 a month and support is offered at no extra cost. The number of seats is unlimited.