If you're seeing "No data found for this time period" when using your AI agent, this guide will help you identify and resolve the most common issues.
Quick Checks
Before diving deeper, try these quick solutions:
Try a broader date range - Expand to the last 30 or 90 days to see if any data appears
Verify recent data might be delayed - Data from the last 24-48 hours may not have been processed yet due to your Snowflake configuration
Verify your agent query - Go to the agent settings page to check your SQL query
Common Data Access Issues
1. Table Access Permissions
Issue: Your Snowflake user lacks permission to access the table.
Solution:
Contact your data team to verify you have the proper access roles
Ensure the
GRANT SELECTpermission has been applied to your user for the specific tableCheck if the table name has changed or moved to a different schema
2. Table Recreation or Schema Changes
Issue: When Snowflake tables are recreated or modified, permissions may need to be reapplied.
Solution:
Inform your data engineer that the table may have been recreated
Request that access permissions be reapplied to the new table
Verify the table structure still includes all required fields (
id,text,creation_date)
3. Missing Required Fields
Issue: The AI agent requires specific fields to function properly.
Solution:
Ensure your SQL query includes the following fields:
id(or equivalent unique identifier)text(the content to be analyzed)creation_date(when the interaction occurred)
Use aliases if your fields have different names:
customer_feedback as text
4. Empty or Invalid Data
Issue: The table exists but contains no rows or invalid data for the selected period.
Solution:
Verify data exists in your Snowflake table with a direct query
Run this example query adapted to your date range:
SELECT COUNT(*) FROM your_table WHERE creation_date BETWEEN '2023-01-01' AND '2023-01-31'Check if date formats match the expected format (YYYY-MM-DD)
5. Table Configuration Issues
Issue: Your connection might be referencing an incorrect table or one that has changed.
Solution:
Confirm the table name and schema in your agent query
Check if the table has been renamed or moved to a different schema
Verify that the table structure includes all required fields
Ensure your account has the correct access permissions to the table
Advanced Troubleshooting
If the above solutions don't resolve your issue:
Check Your Agent Query
Go to the agent settings page to review your SQL query
Verify the table name and schema are correct
Ensure the query includes all required fields (
id,text,creation_date)Consider testing the query directly in Snowflake to validate i
Review Recent Changes
Has your data pipeline changed recently?
Have any Snowflake migrations or upgrades occurred?
Have table definitions been modified?
Still Having Issues?
If you've tried these steps and still can't access your data:
Take screenshots of your Lang.ai configuration and the error message
Note the exact table name and date range you're trying to access
Contact our support team with these details for further assistance
Remember that resolving data access issues may require coordination between your team and your data engineering team, as many solutions require Snowflake administrative privileges.