# Data Store using a Flat File Data Connector
{% hint style="success" %}
*Look at the given walk-through on how to create a Flat File connector based Data Store.*
{% endhint %}
This section describes steps to create a Data Store using a Flat File.
* Navigate to the Data Center homepage.
* Click the ***New*** option.
* Select the ***Data Store*** option from the context menu.
* The Data Connectors page opens.
* Select a Connector Type from the ***Data Source*** filter (E.g., A file data source is selected in the following image).
* Select a data connector from the Data Connector list.
* Click on the ***Create Data Store*** option.
* The ***Getting Data*** tab option opens to create a new Data Store based on a Flat File Data Connector.
### **Getting Data**
* Enter a name for the Data Store.
* The *pre-selected* ***Data Connector Name*** gets displayed.
* Click the ***Choose File*** option to browse a file from the system.
* Select a sheet using the ***Sheet List*** drop-down menu.
* Select an option to display ***Sheet Layout*** using the drop-down menu out of Column Headers or Row Headers.
* Click the ***Next*** option to proceed.
{% hint style="info" %} Please Note: *The user can choose an Excel or CSV file as a file data connector.*
{% endhint %}
### **Data Type Definition**
* Navigate to the ***Data Type Definition*** tab.
* Define the required Dimensions, Measures, and Time by interchanging the categories.
* Enable the Dimensions by using a checkmark to avail LOV lookup in the filter panel of the Self-service BI Report.
* Click the ***Next*** option to proceed.
### **Hierarchy Definition**
Define hierarchy using multiple dimensions or dropping the selecting time fields in the Drill Definition box.
* Navigate to the ***Hierarchy Definition*** tab.
* Click the ***Add*** option provided in the Hierarchy Definition window.
* A new ***Drill Def*** box gets added to the screen.
* Drag and drop the dimensions or time options to define a hierarchy.
* Proceed to the next tab by clicking the ***Next*** option.
### **Data Restrictions**
The Administrator can restrict access to data for a specific user by configuring the User Property via the ***Data Restrictions*** tab.
**E.g.,** If for a user/user group ***Country*** custom field value is ***USA*** and the administrator passes ***Country*** as a User Property while creating a data store. Users for whom ***USA*** was selected as a value for the ***Country*** custom field can access data related only to the USA from the data store.
* Navigate to the
* Click the ***Add*** icon to add a new box for inserting the data restriction parameter.
* Select a dimension using the drop-down menu.
* Enter the user/group-specific custom field to restrict the data.
* Click the ***Finish*** option.
* A success message appears to confirm the data store configuration.
* The ***Data Stores*** list opens.
* The newly created Data Store gets added at the top of the ***Data Stores*** list.
###
###
---
# Agent Instructions: Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter:
```
GET https://docs.bdb.ai/bdb-documentation/data-center/data-stores/creating-a-new-data-store/data-store-using-a-flat-file-data-connector.md?ask=
```
The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.