akfin-metadata.qmd

---
title: Data description
---

```{r setup, include=FALSE}
#| file: functions.R

knitr::opts_chunk$set(echo = TRUE)
```

[AKFIN Answers](https://akfin.psmfc.org/akfin-answers/) is an Oracle BI tool used for distributing data to stock assessors and other users. Usernames and passwords are distinct from direct AKFIN database credentials. 

```{r table-locations, eval = TRUE, echo = FALSE}
 # You can download all of the tables and saving them locally. These are all of the new tables for you to look through:
akfin_views <- RODBC::sqlQuery(
  channel = channel,
  query = "SELECT table_name 
FROM all_tables
WHERE owner = 'GAP_PRODUCTS';") %>% 
  dplyr::filter(grepl(x = TABLE_NAME, pattern = "AKFIN_"))

locations <- akfin_views$TABLE_NAME

str00 <- print_table_metadata(channel, locations) 
```

`r str00` 

```{r rodbc-close}
RODBC::odbcCloseAll()
```