Jira data import to QuickSight issue


Are there limitations in QuickSight when importing data from Jira? I have connected to Jira and I do not see all fields from a table. Could it be be Jira API configured incorrectly? Has someone faced a similar issue?

can you describe the missing fields? it would really help if you have the response from the api as well.

Hi @DigitalMe,

Are you using Direct Query?

Each result set from a direct query can have up to 2,000 columns. Each column name can have up to 127 Unicode characters. If you want to retrieve data from a larger table, you can use one of several methods to reduce the size of the data. You can deselect columns, or apply filters. In a SQL query, you can also use predicates, such as WHERE, HAVING. If your visuals time out during a direct query, you can simplify your query to optimize execution time or you can import the data into SPICE.

Quotas for queries are as follows:

  • 127 Unicode characters for each column name.
  • 2,000 columns for each dataset.
  • 2-minute quota for generating a visual, or an optional dataset sample.
  • Data source timeout quotas apply (varies for each database engine).
1 Like

Hi @DigitalMe. Has your issue been resolved? If so, please help the community by providing solution details and marking the appropriate post as “Solution”. If we do not hear back in the next 7 days, we will archive the question. Thanks for posting your questions on the QuickSight Community Q&A Forum!