Extraction Data Through ADF

[Matheus Malonda dos Santos Macaia]

I'm using azure data factory to extract and process data from jira to create a project feedback dashboard. I would like to know if there is a way to see or create the schema of the tables that are in the database so that I know where the information I need is.
So that I can extract from project boards
Examples of information I need: "Sprint Name", "Logged time", "Story points", "Issues summary", "issues type", "Project Name", "History Issues", "Key", "Status history".

[Nic Brough -Adaptavist-]

Welcome to the Atlassian Community!

There's a couple of things here.

First, you've flagged the question as Cloud.  You have no access to the database on Cloud, so there's no answer to the question.

However, if you meant to say you are on Server or DC Jira, then, although in theory, you could do this, I would very strongly recommend that you do not.

A Jira database is a data-store, with a lot of the logic done in the application.  It's really not intended to be read externally, and if you do go down this route, you're going to spend weeks creating a mass of SQL that probably isn't going to be right, and certainly won't perform.  The list of data items that you are looking for are all in the database, but you'll be having to join 40-50 tables, down multiple layers, many times, and with some calculations (including manipulating XML read from some of it) to get it for a single issue.

For both Cloud and Server/DC, please, forget SQL extraction.  Use the REST API to get the data you need - you can extract all but "board" from your list for a single issue with a single call with that.

[Matheus Malonda dos Santos Macaia]

I need to know the name of the tables that have the data I need. How do I find out table names and what's in them? I used the scheme that is in the documentation but they don't have the information I need

[Matheus Malonda dos Santos Macaia]

OK! So using REST API to extract data, how do I know which tables have the information I need? Can I find this information somewhere? Or extract some scheme that shows me in which tables are the information I need? Also do you have alternative ways to extract data from projects that are in Jira? 

I tried to perform the extraction using the REST API, but it only returned the metadata and there was no table and no information, nothing, just a list of objects.

[Nic Brough -Adaptavist-]

If you use the REST API to read the data, you do not care what the tables are.

When you used the API to extract the data, it will have returned the actual data, not tables or information.  Nor will it have given you a "list of objects", it's given you the data you asked for.