Youcef Zeghiche

Issues with BigQuery Document Search for SQL Queries

Hi, I've uploeaded 2 documents to explain BigQuery tables and label thems. But when the user use the I.A agent SQL to query tables, The agent meets difficulties to find the documents, it failed very often to find the table structure. The search document failed to often. do you know why ?

2Comments

Posted in Help·

Youcef Zeghiche

Need Help Connecting Dust with Slack: Step-by-Step Assistance Required

Hello , I've tried to connect Dust with slack but I have difficulties for the first step ; can i have some help ?

1Comment

Commented on Setting Up Calculation Rules in Dust for BigQuery...·Posted inHelp

Youcef Zeghiche

Okay thank you very much !

Commented on Setting Up Calculation Rules in Dust for BigQuery...·Posted inHelp

Youcef Zeghiche

I'm sure that i will have many semantic problems

Commented on Setting Up Calculation Rules in Dust for BigQuery...·Posted inHelp

Youcef Zeghiche

Oh thanks ! I have a last question : How Can I help dust to anticipate unpredicted user inputs like "give me transformation rate ?" instead of "conversion rate" ?

Commented on Setting Up Calculation Rules in Dust for BigQuery...·Posted inHelp

Youcef Zeghiche

Oh super thanks ! for exemple this format is good for dust ? do you think dust understand my business logic which is displayed below ?

sales_transactions
This table contains successful transactions.

Table Fields:

0.transaction_attempt
Description: Unique identifier for the attempt of the transaction.

1.transaction_id
Description: Unique identifier for the transaction.

2.customer_id
Description: Unique identifier for the customer who made the transaction.

3.product_id
Description: Unique identifier for the purchased product.

4.transaction_date
Description: Date and time of the transaction.

5.quantity
Description: Number of units of the product purchased.

6.total_amount
Description: Total amount of the transaction in local currency.

payment_method
7.Description: Payment method used (card, cash, bank transfer, etc.).

8.store_location
Description: Location of the store where the transaction took place.

Business logic
1. conversion_rate : transaction_attempt / transaction_id

2. Etc....

Commented on Setting Up Calculation Rules in Dust for BigQuery...·Posted inHelp

Youcef Zeghiche

Great, thanks! Abboud Hammour, I have about ten analytical tables (transformed, cleaned, and ready to be queried) with different levels of granularity and different calculation rules. Do you recommend creating a single text file for all tables or one for each table? Should I also follow a specific format?

Posted in Help·

Youcef Zeghiche

Setting Up Calculation Rules in Dust for BigQuery Integration

Hello, I have connected Dust with my Bigquery table and it's so great ! Now I don't know how/where to give rules about my table. Indeed, Dust can't guess which columns choose to make a rate or calcul field. For exemple I would like ask to dust : "What is my conversion rate ? " but Dust dosen't know which columns choose to make the calcul There is a place where I can give all calculated rules which are related to the questions coming from no-data users ? Thanks in advance

11Comments